Purge the audit log

You can improve the performance of Vernon CMS by purging the audit log.

Overview

The audit log tracks data changes in your system, and can report on and undo data changes. The stored data will build up, which can slow down Vernon CMS. You can purge the audit log but keep a reasonable amount of data so you can undo changes if necessary.

Schedule the purging of the audit log on a fortnightly, monthly, or quarterly basis depending on how heavily you use the system.

It's best to purge the audit log when few people are using the system, as purging can slow the system down.

Steps

  1. Go to the Wincoll > DATA folder and copy the LOGS folder to an external storage device. This can be part of your regular backup schedule.

  2. Go to the Tools menu > System Maintenance > Audit > Transaction Report.

  3. In the To Date field, enter a date at least 3 months before today.

  4. Select the transactions to remove (Change, Add, Delete).

  5. Select Purge Afterwards.

  6. Click Go.

  7. When you perform the purge, the transaction report will appear in a preview window. You can save the report of all purged records.

  8. Click Yes to purge the audit log when prompted.