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