Audit Query by Table/Field/Key

Once Auditing is activated, 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 Table, Field and Key value to isolate changes. To access this query, navigate to the Audit Query By Table/Field/Key menu option on the Administration menu.

Specify any the following values for the filters:

• Audit Table Name: The name of the table that has been audited to query. When this table is chosen the screen will list additional fields to filter upon.

• Audit Field Name: The name of the field to track to filter the results.

• 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:

• Create Date/Time: Date and time the changes were made.

• User Name: Name of user who made the changes.

• Primary Key: Record key of the change.

• Audited Field Name: Name of field that was changed.

• Audit Action: Action that was recorded with change (i.e. Insert, Update or Delete)

• Value Before Audit: The field value before the change was made.

• Value After Audit: The field value after the change was made.