- 27 Mar 2024
- 2 Minutes to read
- Contributors
- Print
- DarkLight
Audit Tables
- Updated on 27 Mar 2024
- 2 Minutes to read
- Contributors
- Print
- DarkLight
Audit Tables H
Note
Use this page to Enable Audit Trail for a Data Source.
To access this page in System Administration:
Click Data Sources in the Navigation pane.
Click the Audit icon for a data source.
Click the Tables icon.
Field | Description |
---|---|
TABLE NAME | Displays the name of the audited data source table. |
ENABLE AUDITING | If checked, an audit trail is enabled for the table. |
AUDIT PROCEDURES | If checked, a record of every stored procedure that runs against a record as part of a Syniti Construct Page Event is maintained in the audit tables. |
BUILD AUDIT TABLES | Click to create audit tables in the specified Data Source to track changes to the selected user table.
|
SNAPSHOT DATA | Click to create a copy of the tables with a snapshot of the data currently in the table. This process must be run after creating the audit tables. When a record is edited, the audit trail records both the before and the after values. However, the trail only shows values that are edited. Snapshot Data can be viewed as an insert for existing records. If the audit is enabled after the table has values in it, the trail has no way of telling where the data came from, so the snapshot is a way of verifying that some data existed prior to auditing. |
CHECK COLUMNS | Click to report any differences between the columns in the table and the audit table. When the audit tables are built, all the columns from the table that are being audited are included. However, it is possible to have a case where the columns in the table and the audit tables do not match. There can be two reasons for the misalignment:
|
Audit Tables V
Field | Description |
---|---|
Table Name | Displays the name of the audited data source table. |
Drop Tables | |
Request Drop | Click to request that the audit tables be dropped. Another user with Administrator rights must confirm within 24 hours before the audit tables can actually be dropped. |
Drop Requested By | Displays the name of the user who requested that the audit tables be dropped. |
Drop Requested On | Displays the date on which a user requested that the audit tables be dropped. |
Drop Audit Tables | Click to drop the audit tables. This button is enabled after another user with Administrator rights requests that the audit tables be dropped. |