How to print: Complete the Print Security Audit Reports Screen with the User authority changes flag selected.
For more information: See the sample report in PDF format.
Note: This report is also available as a .csv (comma-separated value) file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in CSV (Spreadsheet) Format for more information.
Contents:
• Date range: The date range selected at the Print Security Audit Reports Screen
• The ID and description affected by the activity. If the activity relates to:
• A user control record (Users table, updated through Advanced Commands or WUSR): user ID and user name from the User Control screen
• Any other update to a user-related table: user ID and name from Work with Users
• Any update related to a user class: user class code and description
• Secured feature updates: secured feature code and description
Name changes: If the activity changed the name of the record, the PDF report displays the name before applying the change; however, the CSV file includes the previous name in the before record and the changed name in the after record.
Sorting: Users, user classes, and secured features are listed alphabetically by ID or code. If there were updates to both the Users record and another user-related table for the same user ID, the report first lists activity related to the User table, then the Users table, then any additional activity for other user-related tables.
Activity details: For each activity related to a user, class, or secured feature:
• Date: The date when the activity occurred.
• Time: The time when the activity occurred.
• Table: The table updated by the activity and tracked in the User Audit table. See Fields Used by Updated Table (User Audit) for a listing of possible tables.
• Action: Indicates the type of activity:
• A = add: includes an after image of the new record
• C = change: includes a before image and an after image of changed fields
• D = delete: includes a before image of the deleted record
• Updated by: The user ID of the person performing the activity.
• Fields: Provides information on the activity:
• Before indicates the record before a change or deletion, for example: Before: Status *DISABLED
• After indicates the record after an addition or change, for example: After: Status *ENABLED
• Lists each new or changed field name with the previous setting (before image) or current setting (after image), for example: After: Advanced Commands: Y Password Expired: 04/20/2015
• The Fields column of the PDF report can include up to 75 positions. If the affected fields require more than 75 positions to list, you need to download and open the CSV version of the report to review the complete contents. In this case, the Fields entry indicates See CSV report (data exceeds boundary of report)
For more information: See User Audit Table Updates and Fields Used by Updated Table (User Audit) for more information on how different types of activities update the User Audit table.
