VSys One: Volunteer Management Software

Previous Topic

Next Topic

Book Contents

Book Index

Purge Old Trace Records

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.

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 trace table, or simply summarize existing records.

Steps in this task

  1. Open the Purge old trace records tool 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 button. VSys will count the records that meet the actions and date criteria you specified.

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

To prevent even VSys One administrators from purging these records, revoke UPDATE and DELETE rights for the "trace" table on the server 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.

VSys uses the trace table to keep track of what reminders have been generated ("Reminder via e-mail" and "Reminder via SMS"). If you drop or empty the trace table, or use the Purge old trace records tool on recent records, VSys may lose track of which events have been sent their notifications! Therefore, only purge trace records which are old - nothing in the past few months.

"Debug" records can be purged at will. Older versions of the VSys Kiosk posted "debug" records whenever it ran the automatic checkout tool and if several copies of the kiosk were running this could result in large numbers of unneeded trace records. Purging "debug" records - even recent ones - has no negative consequences.

See Also

Tools

Apply Certification Automatic Creation Rules

Attachments Analyzer

Automatically Create Eligibility/Intake Checklists

Backing Up Your Data

Bulk Value Updater

Check for Duplicated IDs

Check for Program Updates

Check for Zip/Postal Code Updates

Concurrent Users Monitor

Create and Manage Data Encryption Keys

Database Merge Tool

Enter VSys One Registration Codes

Find Duplicate Assignments

Fix Recurring Assignment Detail Gaps

Letters Purge Tool

License Information

Make a Local Backup of VSys One in Another Folder

Photo Resize Tool

Index Update Tool

Recalculate the Bonus Hours for Volunteer Hours

Recalculate the Value of Volunteer Hours

Restore From a Backup

Special Table Tools

SQL Commands to Database

Table Permissions Diagnostics