Thursday, May 17, 2012

SharePoint Logging

Using SSRS you can audit SharePoint
http://aaclage.blogspot.com/2011/11/create-reports-with-sharepoint-2010-and.html

If you need to create the database just continue.

SharePoint 2010 logs are very helpful, but in a large enterprise there has to be a better way.  After a little digging I have found something that has great potential.  First I ran across an article in MSDN. 
Using CA enable the following timer jobs using monitoring > review job definitions and enable the Diagnostic Data Providers that you wish to capture.
image
Make sure your diagnostic and trace logs are set to appropriate Event and Trace Level. 
Verify your settings and make sure that Event Log Flood Protection is enabled.
image
Now the data is being captured in a centralized database for you to use as you wish. 
Lets use Microsoft SQL Server Management studio to verify that data is being collected.  So after you wait for your timer job to fire open SQL Management Studio while the right credentials.  I use the following trick, holding down the SHIFT key and then right click the icon, select run as different user.
image
Connect and Right click the WSS_Logging Database and run the Disk Usage by Top Tables Report
image
Look for ULSTraceLog_PartitionXX . 
Where XX is the partition number and use that to run a quick query against that table.
image
Now that we have verified your database working you can use any tool such as BCS to connect to the data.
image
Here are my references and more reading.  Having fun with SharePoint.

References
Debugging and Logging Capabilities in SharePoint 2010 (MSDN)
http://msdn.microsoft.com/en-us/library/gg512103.aspx

Using Business Connectivity Services to Display SharePoint 2010 ULS Logs
http://www.shillier.com/archive/2010/08/05/Using-Business-Connectivity-Services-to-Display-SharePoint-2010-ULS-Logs.aspx

Performance Counters
http://technet.microsoft.com/en-us/library/ff383289.aspx

Configure diagnostic and Trace Logging (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/ee748656.aspx

ULS Viewer
http://archive.msdn.microsoft.com/ULSViewer

How often should the auditing log be cleared to not affect performance?http://sharepoint.stackexchange.com/questions/17151/how-often-should-the-auditing-log-be-cleared-to-not-affect-performance

No comments:

Post a Comment