.
The Audit History report lists changes made to the following types of records:
▪ User
▪ Role
▪ Entity class
▪ Property class
▪ Project class
When you run the Audit History report, the system gathers data from the database specified on the Audit Settings view of Security Console for Windows. The report processes the MRICLDEF_Audit table for the given database and compares the BEFORE and AFTER fields of the records listed above to determine any changes, and then individually lists each change as a line item.
The Audit History report creates a Microsoft Excel workbook that contains the following columns with audit history information for the current client ID:
▪ Batch ID—The ID or batch number associated with the change that was made. This column can be used to group changes that occurred at the same time.
▪ User ID—The ID of the user who made the change.
▪ SCIM—The functionality that caused the update. The column displays a 'Y' if the change was made by SCIM or an 'N' if it was made in Security Console.
▪ Modified Object—The ID of the modified user, role, or class.
▪ Database—The database in which the change was made.
▪ First Name—The original first name of the modified user.
▪ Last Name—The original last name of the modified user.
▪ Email—The original email address of the modified user.
▪ Field—The field that was modified.
▪ Change Type—The type of change that was made. The possible values are Add, Modify, and Delete.
▪ Original Value—The original value of the modified item. The column displays a 'Y' or an 'N' to represent whether or not a check box was selected.
▪ New Value—The new value of the modified item. The column displays a 'Y' or an 'N' to represent whether or not a check box is selected.
▪ Date/Time—The date and time when the change was made.
Note
You must have Report Access permissions to run this report. Refer to Adding and Maintaining Users and Access Rights for more information.
To run the Audit History report, follow these steps:
1. If you have super
administrator rights, enter the appropriate Client ID in the Client
ID Override field in the user profile .
2. Go to Reporting.
3. In the Report field, select Audit History Report.
4. Enter the Begin Date and End Date for the report.
5. In the Databases field, select one or more databases for which the report should be run.
6. Optionally, select the Display Admin Rights checkbox to include an additional Admin Rights Changes tab on the Excel output, which displays any changes that have been made to admin rights within the selected date range.
7. Click Run.
8. When the report has finished running, click Download Report. The report can also be downloaded later by clicking the Work Requests button in the upper-right corner of Security Console.