How can the Search Log, Questionable Access and Viewed Messages Reports history be cleared (4272956)

How can the Search Log, Questionable Access and Viewed Messages Reports history be cleared

Testing will leave history in the reports

These reports read from the SearchLog, MessageLog and AttachmentFileLog in the Archive Manager database.

To remove all history run the following queries in SQL Management Studio against the Archive Manager database.

NOTE: This will remove all the history and is not recoverable. Ensure you have a valid backup of your databse before proceeding:

Delete from Searchlog
Delete from MessageLog
Delete from AttachmentFileLog
 

If only information for specific users needs to be removed the following queries can be used to clear the Questionable Access and Viewed Messages. Replace xx with the user loginID:

Delete from MessageLog where loginID = xx

Delete from AttachmentFileLog where LoginID = xx