Solved

SharePoint - log in request tracking

Posted on 2010-08-16
7
701 Views
Last Modified: 2012-05-10
What is the best way to see which users accessed a web app on a particular day.  Must be something other than Usage Reporting / Web Analytics.  Our environment is SharePoint 2010.
0
Comment
Question by:Justin Smith
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:dp_expert
ID: 33452195
OOB there is nothing. What you are missing from the Usage Reporting?
0
 
LVL 38

Author Comment

by:Justin Smith
ID: 33453785
No way through IIS logs or anything?  what about the ULS logs of 2010?

Web Analytics database was messed up, so it doesn't have the data we need for the particular day.
0
 
LVL 15

Expert Comment

by:dp_expert
ID: 33453916
You can find something in IIS logs - depending on how it was configured. We used to use the IIS logs to monitor our Sharepoint-based site usage, so this could be a goog lead. Depending on how you had it set up.
Do you have IIS 6 or 7?
The same goes with ULS - if it was set up to higher filtering levels then you wouldn't get too much.
What info you need to find? Who has accessed given web page or who has done some action (deleted something)?
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 38

Author Comment

by:Justin Smith
ID: 33453927
IIS 7

We wanted to know which users accessed any SharePoint sites on a particular day.
0
 
LVL 15

Accepted Solution

by:
dp_expert earned 500 total points
ID: 33453976
Ok
On my test environment with all standard settings in the IIS 7.0 I have found info about users in this form:
2010-08-16 12:16:27 fe80::4055:d528:f05c:4762%16 GET / - 80 DEVX64\Administrator fe80::d154:9bbb:c2de:b6e0%16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.1;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+Tablet+PC+2.0;+InfoPath.3;+MS-RTC+LM+8;+.NET4.0C) 200 0 0 15441
 2010-08-16 12:16:49 fe80::4055:d528:f05c:4762%16 GET /Pages/Default.aspx - 80 devx64\administrator fe80::d154:9bbb:c2de:b6e0%16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.1;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+Tablet+PC+2.0;+InfoPath.3;+MS-RTC+LM+8;+.NET4.0C) 200 0 0 21453
 - so you get the date, page address and user login and IP (here it's v6) . So if you havn't changed anything in your IIS settings you should get the same.
Sorry, I forgot about the IIS logs.
0
 
LVL 38

Author Comment

by:Justin Smith
ID: 33454029
thanks boss.  I tried using a IIS log parser on codeplex but it didn't really give me user info.  I'll look a bit closer based on your response.
0
 
LVL 15

Expert Comment

by:dp_expert
ID: 33454070
I usualy just use Excel - copy the data and split it by space character. Needs a bit fiddling afterwards but does the job quite well.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now