Set Up Data Change Event Logging
Set Up Data Change Event Logging
Web Central ships with a workflow rule
AbSystemAdministration-DataChangeLogger
for Data Change Event logging. When a user accesses a Smart Client or a Web Central form to change a record in a specified table, the workflow rule logs the single-record or bulk update in the database event log.
The event log contains the following:
- Table name
- Name of the user making the change
- Date and time
- SQL that created a bulk update or the primary key and changed fields for a single-record update.
The event log records these changes:
-
record insertion
-
record deletion
-
a record's changed value
Step 1: Enable Data Event Logging
This workflow rule is disabled by default. To enable Data Events logging:
-
Run the System / Add-In Manager / Define Workflow Rules view and set the
AbSystemAdministration-DataChangeLoggerworkflow rule to Active. -
To apply the changes, restart Web Central.
Note
: When upgrading to V.20.2 or later, users with older databases should find and rename the workflow rule
SecurityTablesDataChangeLogger
to
DataChangeLogger
before enabling this workflow rule.
Step 2: Specify the Tables for which Events are Recorded
The application parameter
AbSystemAdministration-DataChangeEventTablesToLog
contains the list of table names for which the workflow rule will log events. The default list of tables is:
afm_users, afm_groups, afm_roles, afm_groupsforroles
,
afm_wf_rule
, and
afm_flds
.
The System Administrator can change this list of tables by running the
System / Archibus Administrator - Application Configuration / Configure Application Parameters
task and editing the
AbSystemAdministration-DataChangeEventTablesToLog
application parameter. The application parameter can contain either "%", indicating all tables, or a list of tables: "rm;bl;fl".
Review the Data Change Events Log
As Archibus users make changes to the specified tables, these change events are recorded in the Archibus Data Event Log table (
afm_data_event_log
).
The System Administrator can review log records in the Data Event Log table using the System / Archibus Administrator - User and Security / View Data Events Log task. See Data Change Events Log.