Audit Query By User
Once Auditing is enabled changes are logged in the configured Audit Table using the Audit Program specified in the configuration. It is possible to query this Audit information by individual users to isolate changes made by that user. To access this query, navigate to the Audit Query By User menu option on the Administration menu.
Specify any the following values for the filters:
Value
Description
User ID
Authorization User to track.
Audit Table
The name of the table containing the audit information.
Creation Start Date/Time and Creation End Date/Time
Date and time range to limit the records returned.
The query will return the following results:
Result
Description
Row Creation Date
Date and time the changes were made.
Audited Table Name
Name of table that was audited.
Primary Key
Record key of the change.
Audited Field Name
Name of field that was changed.
Audit Action
Action that was recorded with change (Insert, Update or Delete).
Field Value Before Audit
The field value before the change was made.
Field Value After Audit
The field value after the change was made.