ARCHIBUS Web Central

Data Change Event Logging

Web Central ships with a workflow rule AbSystemAdministration-DataChangeLogger for Data Change Event logging. When a user uses 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.

Enabling Data Event Logging

This workflow rule is disabled by default. The System Administrator can enable Data Events logging using the System Administration/ARCHIBUS System Administration/Add-In Manager/Define Workflow Rules view and enabling the AbSystemAdministration-DataChangeLogger workflow rule. To apply the changes, the System Administrator should restart Web Central. Please note that when upgrading to v20.2 or later, users with older databases should find and rename the workflow rule SecurityTablesDataChangeLogger to DataChangeLogger before enabling this workflow rule.

Editing the List of Tables

The application parameter AbSystemAdministration-DataChangeEventTablesToLog contains the list of table names for which the workflow rule should log events. The default list of tables is: afm_users, afm_groups, afm_roles, afm_groupsforroles, and afm_roleprocs. The System Administrator may change this list of tables. This can be done in the System Administration/ARCHIBUS Administrator - Application Configuration/Configure Application Parameters view by editing the AbSystemAdministration-DataChangeEventTablesToLog application parameter. The application parameter can contain either "%", indicating all tables, or a list of tables: "rm;bl;fl".

Data Events Log View

The ARCHIBUS Data Event Log table (afm_data_event_log) is an auto-numbered table containing Data Event logs.

The System Administrator can use the System Administration/ARCHIBUS System Administration/ARCHIBUS Administrator - User and Security/View Data Events Log view to review log records recorded in the Data Event Log table.

The view displays all fields from the Data Event Log table.
The records are sorted by Timestamp initially.
The user can filter records by:
- Any field from the Data Event Log table
- A date range

For additional information on this topic, see Data Change Events