Solved

SharePoint - log in request tracking

Posted on 2010-08-16
7
719 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

623 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