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 .
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.