Auditing

Actions, which are initiated by either an operator or an application, are audited in the database. A list of the audited actions for Business Rules is shown in Table 2.

The audit data for each action is found in the following tables:
  • The audit information (audit_info) table, which contains the following data:
    • The timestamp when the action occurred.
    • The source that initiated the action. For example, a logged-in user or a back-end server.
    • The component that did the action.
    • The action that was done.
  • The audit details (audit_details) table, which contains the following data:
    • The name of the type of value.
    • The data value.

In addition, each component has a database view that defines the audit data for the component. For Business Rules, this table is called business_rules_audit and contains data from the audit information and audit details tables. The columns from the audit details table that appear in the business_rules_audit view are specific to Business Rules.

The following table shows the columns and an example of the data that is contained in the business_rules_audit view.
Table 1. Definition of the Business Rules audit database view
Column name Source table Example values Description
Created audit_info   Timestamp that indicates when the action occurred.
Component audit_info The Business Rules components are:
  • User interface
  • Business Rules Manager
  • Business Rules Server
 Identifies the component that was affected by the action.
Source audit_info For each Business Rules component, the matching source values are:
  • The user ID that is logged in.
  • <IP address>:<RMI port number> from the properties file
  • <IP address>:<port number> from the properties file
 Identifies the requester of the action.
Action audit_info Update environment, Table export, Copy release The action that was done.
In/From Env audit_details Test, Environment1 Environment name for the source of the action. For example, the copy action would copy from this environment.
To Env audit_details Production, Environment2 Environment name for the destination of the action. For example, the copy action would copy to this environment.
In/From Rel Id audit_details 1 Release number for the source of the action. For example, the copy action would copy from this release number.
To Rel Id audit_details 2 Release number for the destination of the action. For example, the copy action would copy to this release number.
In/From Rel Name audit_details rel1070700 Release name for the source of the action. For example, the copy action would copy from this release name.
To Rel Name audit_details rel1070900 Release name for the destination of the action. For example, the copy action would copy to this release name.
Table Name audit_details Field Identifies the table name that is used by the action.
Primary Key audit_details { PK1 = 1, PK2 =- 4} Name and values for the primary key of table name.
In/From Record audit_details { name = Dev, schema = rules, description = Development, promotionOrder = 1, lastUpdateUserId = adminid, releasekeepcount = 600, releasekeepdays = null } The entire rule before the action was done.
To Record audit_details { name = Dev, schema = rules, description = Development, promotionOrder = 2, lastUpdateUserId = adminid, releasekeepcount = 800, releasekeepdays = 12 } The entire rule after the action was done.
Modified Fields audit_details { promotionOrder = 2, releasekeepcount = 800, releasekeepdays = 12 } Identifies the fields that were changed in the rule.
The following table shows a list of actions that are audited in the Business Rules user interface. It is an example of the report that is generated by the comparison process. It also shows which fields in business_audit_view are populated by each action.
Table 2. Audit Actions - Business Rules user interface (business_audit_view)
Action In/From Environment In/From Release ID In/From Release Name To Environment To Release ID To Release Name Table Name Primary Key In/From Record To Record Modified Fields
Update environment Environment name     Environment name     Environment Key name and values Original record New record Modified fields
Delete environment Environment name           Environment Key name and values Original record    
Add Release       Environment name Release number Release name Release Key name and values   New record  
Update Release Environment name Release number Release name       Release Key name and values Original record New record Modified fields
Delete Release Environment name Release number Release name       Release Key name and values Original record    
Copy release Environment name Release number Release name Environment name Release number Release name     Original record New record Modified fields
Promote release Environment name Release number Release name Environment name Release number Release name          
Activate release Environment name Release number Release name                
Reactivate release Environment name Release number Release name                
Lock release Environment name Release number Release name       Table name Key name and values Original record New record Modified fields
Table import       Environment name Release number Release name Table name     New record  
Table export Environment name Release number Release name       Table name   Original record    
Insert records Environment name Release number Release name       Table name   Original record    
Update records Environment name Release number Release name       Table name Key name and values Original record New record Modified fields
Delete records Environment name Release number Release name       Table name Key name and values Original record    
Table manual edit (delete) Environment name Release number Release name       Table name   Original record    
Table manual edit (insert) Environment name Release number Release name       Table name   Original record    
Table manual edit (update) Environment name Release number Release name       Table name   Original record    
Table manual edit (copy) Environment name Release number Release name       Table name   Original record    
Update property             Table name Key name and values Original record New record Modified fields
Import record (insert)       Environment name Release number Release name Table name        
Import record (update)       Environment name Release number Release name Table name        
Import record (delete)       Environment name Release number Release name Table name        
Update range configuration Env1           Table name Key name and values Original record New record Modified fields
Create locks Environment name Release number Release name       Table name Key name and values Original record    
Delete locks                      
Delete locks by environment Environment name                    
Delete locks by user ID                 Userid=adminid    
Delete locks by session ID                   sessionid=SESSION_ID  
Delete locks by table             Table name        
Delete locks by selection Environment name Release number Release name       Table name Key name and values Original record    
Add user preference             Table name Key name and values   New record  
Update user preference             Table name Key name and values Original record New record Modified fields
Add descriptor Environment name Release number Release name       Table name Key name and values   New record  
Update descriptor Environment name Release number Release name       Table name Primary Key = PK Original record New record Modified fields
Delete descriptor Environment name Release number Release name       Table name Key name and values Original record    
Update prefix information Environment name Release number Release name       Table name Primary Key = PK Original record New record Modified fields
Add IBM field information             Table name Key name and values   New record  
Update IBM field information             Table name Primary Key = PK Original record New record Modified fields
Delete IBM field information             Table name Key name and values Original record    
Note: XML String in the descriptor is not audited.