Purge Old Trace Records

Concepts

This tool allows administrators to permanently remove old "trace" records, which are audit logs of most activities in VSys. These logs include logging in, viewing records, creating values, printing reports, sending letters, and security exceptions. If tracing is enabled, these and many other actions leave a trail indicating what actions were performed and who performed them. This table can get large. Use this tool to purge old records from the table, or simply summarize existing records.

When to Use

If the trace table becomes excessively large, or records appear in tracing which are simply not relevant, purge out old trace records or just those which you don't care to retain.

Steps in This Task

  1. From the VSys One main screen, click on Purge old trace records from the Administrator tools panel.

    Linked Graphic

  2. Select the actions to be purged or summarized, and the date range. Only records of these types and between these dates (inclusive) will be summarized or deleted.
  3. Click on the Summarize records link. VSys will count the records that meet the actions and date criteria.

    Linked Graphic

This operation may take some time, depending on the number of records and the speed of your database server.

  1. Check the counts of records.
  2. If these counts look right, and you want the records deleted, click the Purge button to delete them. A confirmation window opens warning you that this action will purge the records from the trace table and that it cannot be reversed. Once started, this operation cannot be cancelled.

    Linked Graphic

We recommend that you back up your database before this operation is performed. See Backup the Database for details on backing up your VSys data.

To prevent even VSys One administrators from purging these records, revoke UPDATE and DELETE rights for the "trace" table for users. This table and the "zips" table are the only tables for which these rights can be revoked without VSys having serious problems. When VSys goes to purge records trace records without the appropriate rights on the database, VSys will throw an issue report.