Viewing and Clearing Audit Reports

Audit results are recorded in the HSP_AUDIT_RECORDS table, stored in the relational database. To clear the audit report, use the SQL DELETE command on the HSP_AUDIT_RECORDS table. To clear entries that are a certain number of days old, compare them against the time_posted field. For example, to delete all entries from the table:

DELETE FROM HSP_AUDIT_RECORDS

To view audit records, sorted by the time they were posted:

SELECT * FROM HSP_AUDIT_RECORDS ORDER BY TIME_POSTED