Audit Query by User

This transaction is used to view changes made by a user that are stored on a given Audit Trail File.

CAUTION:

The system only audits changes that you've told it to audit. Refer to The Big Picture Of Audit Trails for more information.

Navigate to this page by selecting Admin Menu > Audit Query By User.

Description of Page

To use this transaction:

Enter the User ID of the user whose changes you wish to view.
Enter the name of the table on which the audit trail information is stored in Audit Table. Refer to The Audit Trail File for more information about this field.

Note: Default Note. If only one audit table is used to store audit trail information, that table is defaulted.

Specify a date and time range in Created between to restrict the records that result from the query.

Note: Default Note. The current date is defaulted.

Click the search button to display all changes recorded on a specific audit table associated with a given user.

Information on this query is initially displayed in reverse chronological order.

The following information is displayed in the grid:

Row Creation Date is the date and time that the change was made.
Audited Table Name contains the name of the table whose contents were changed.
Primary Key is the prime key of the row in the Audited Table whose contents where changed.
Audited Field Name is the name of the field that was changed.
Audit Action indicates whether the row action was Add, Change or Delete.
Field Value Before Update contains the content of the field before the change. This column is blank if information was Added.
Field Value After Update contains the content of the field after the change. This column is blank if information was Deleted.