If enabled by CUSTOM_FEATURES an audit record is created with each report query. The audit record shows:

• email
• database
• sql
• parameters
• timestamp
• report name

Audit records can be viewed using Audit records from the admin menu or through each users’ audit record from the users admin menu. The records are saved to the application database. By default, 45 days of audit records are retained. This can be changed using the CUSTOM_REPORT_AUDIT_AGE_DAYS environment setting.

Only members of the admin group can view audit records or change the audi records reports.

Actions such as changing a report or updating a comment are recorded in audit logs.

All report editing is recorded as an audit log and can be viewed in the updates section when editing a report.

Audit records are kept in the administration database of Secure Reporter. You should secure that database so that only authorized users can change audit records.

By default 45 days of audit records are retained. The days to keep can be adjusted by using the CUSTOM_REPORT_AUDIT_AGE_DAYS environment variable. The clean up is undertaken every hour.