Solved

SharePoint - log in request tracking

Posted on 2010-08-16
7
712 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

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…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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