Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SharePoint - log in request tracking

Posted on 2010-08-16
7
Medium Priority
?
727 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

971 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