Audit history (SM205530)
You can use this window to view the audit trail of the audited window or the recorded database table changes that are associated with the modifications of the documents made by using the audited window. The audit trail shows the user who modified the document, the date and time of the update, and the details of the modification of the selected database table. You can filter the modifications that you view in any audited database table by user and by date range.
The window toolbar
. The form-specific buttons are listed below.
| Button | Description |
|---|---|
| Manage | Opens the Audit (SM205510) window for the selected audit. |
The top part
You use this area to specify the window and database table associated with the window for which you want to view the audit trail. You can also specify a particular user and date range.
| Element | Description |
|---|---|
| Window ID | Required. The ID and the name of the screen (window) whose audit trail you want to see. |
| User | The user who made the changes. Select a user if you want to view the changes made by the user. You can leave the box blank to view all recorded changes. |
| Start date | The start date of the date range during which the changes took place. Specify a date if you want to view the changes made starting with this date. |
| Table name | Required. The database table for which you want to see the audit trail. |
| End date | The end date of the date range during which the changes took place. Specify a date if you want to view the changes made up to this date. |
The Records table
This table displays the records of the modifications of the selected database table.
The contents of this table depend on the database table you selected in the Table name field.
The Events table
This table shows who changed the record, when were the changes made, what operation was done, and the details of the modifications of the database table.
| Column | Description |
|---|---|
| Operation | The type of recorded operation. |
| Date and time | The date and time of the event. |
| User | The user who modified the record. |
| Record columns | The columns that display the changes in the selected record. If a column is blank, the value in the column was unmodified. |