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.
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.
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.
Connect and Right click the WSS_Logging Database and run the Disk Usage by Top Tables Report
Look for ULSTraceLog_PartitionXX .
Where XX is the partition number and use that to run a quick query against that table.
Now that we have verified your database working you can use any tool such as BCS to connect to the data.
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