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-DataChangeLogger workflow 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.

Set Up Data Change Event Logging

Step 1: Enable Data Event Logging

Step 2: Specify the Tables for which Events are Recorded

Review the Data Change Events Log

See Also