Audit Query by User
Once auditing is activated, changes are logged in the configured audit table by the selected audit class or program, and you can query the audit information by using users as search filters.
To perform an audit query, navigate to the Administration menu, select the Audit Query By User menu option, and specify your search filters:
• User ID
• Audit Table
• Creation Start Date/Time and Creation End Date/Time - Date range comprising the dates and times when changes were made to the fields
The query results provides the following information for the selected User ID:
• Row Creation Date/Time
• Audited Table Name
• Primary Key
• Audited Field Name
• Audit Action (Insert, Update, or Delete)
• Field Value Before Audit
• Field Value After Audit