Archive for the ‘Excel’ Category

Problem Description: Issues downloading the Content Viewing Audit report from Sharepoint site. Every time you try to run the report it just times out or brings up a login box.

Notes: This requires us to trim the audit logs for the site to a certain date. This is actually a reason that users need to set specific audit on only items that actually requires it. What happens is that the table holding all the audit information grows too large, and becomes unresponsive.

Resolution:

stsadm -o trimauditlog    -url <URL name>    -date <YYYYMMDD>    -databasename <database name>    [-databaseserver] <database  server name>

Referrence: http://technet.microsoft.com/en-us/library/cc706879.aspx