web
You’re offline. This is a read only version of the page.
close


Posted Fri, 13 May 2016 16:35:54 GMT by Tim Walsh Solutions Intagrator

My customer, University of West Geoagia has accumulated 12 gigs of of data in the sql table. They want to purge the audit log of some entries but not all. Is ther any documentation regarding best practices on how to best achieve this?

What is the reccommened procedure for purging the audit log of aged entries?

We would like to do this before we perform an upgrade form their current version to ver. 6.9.

 

Thanks

Posted Fri, 13 May 2016 16:51:09 GMT by Patrick Seresin Product Quality Support Analyst

Tim,

It would just be a matter of running a query on the Audit_Log Document Type, then deleting the records you need to purge. See below from our Help Files:

Purging the Audit Log
Depending upon how many database-related user activities you’re logging, and the size of your user base, your audit log can quickly become quite large. Fortis provides a tool to let you purge selected data in your audit log.

Do the following to purge entries from your audit log:

Create and run a Query, using the Audit Log Document Type, to find obsolete data in your audit log. 
Select the audit log entries to delete. 
Choose Audit Trail Purge from the Tools menu. Fortis asks if you to confirm that you want to delete the selected audit log entries. 

Note: Purging records from the audit log has no effect on the original documents or data referred to in the log.

You must be signed in to post in this forum.