Audit Query by Table, Field, and Key
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 tables, fields, and keys as search filters.
To perform an audit query, navigate to the Administration menu, select the Audit Query By Table/Field/Key menu option, and specify your search filters:
• Audit Table Name - Select a table to list additional filters
• Audit Field Name
• 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:
• Create Date/Time
• User Name
• Primary Key
• Audited Field Name
• Audit Action (Insert, Update, or Delete)
• Value Before Audit
• Value After Audit