Audit table information

The amp_audit, amp_audit_action and amp_audit_detail tables in the database contain the auditing data. They are created at the time of the first data upload occurs from a configuration distribution peer (CDP) datastore. The amp_audit table is the master table. The amp_audit_action table contains time stamps and joins with amp_audit on AUDIT_ID. The amp_audit_detail table contains name/value pairs and also joins with amp_audit on AUDIT_ID. Details about the fields in each table are shown in the following tables.

Fields in the amp_audit table

Field

Description

ID

Unique record identifier and primary key

Entity_Category

Type of BMC Atrium Orchestrator component being audited, user login, process scheduled

RBA, PEER, ADAPTER, MODULE, DEV_STUDIO, DATA_REPOSITORY, USER, JOB

Entity_Name

Specific BMC Atrium Orchestrator component, user name associated with login, process scheduled

Grid_Name

Name of the grid on which the BMC Atrium Orchestrator component resides or the process is scheduled to run
Note: The BMC Atrium Orchestrator entity name CDP indicates the grid creation. Grid creation does not generate a separate entry.

Peer_Name

Name of the peer on which the BMC Atrium Orchestrator component resides or the process is scheduled to run 

GRID_ID

Identification number assigned to the grid on which the BMC Atrium Orchestrator component resides or the process is scheduled to run

PEER_ID

Identification number assigned to the peer on which the BMC Atrium Orchestrator component resides or the process is scheduled to run (if any peer selected for the process, no ID is listed)



Fields in the amp_audit_detail table

Field

Description

ID

Unique record identifier and primary key

NAME

Audit item for which VALUE is captured:
GRID_TYPE, PEER_NAME, PEER_TYPE, ADAPTER_TYPE, ADAPTER_CATEGORY, MODULE_CATEGORY, MODULE_CHILDREN, STATUS, LAST_STATUS_BY_USER, SOFTWARE_NAME, SOFTWARE_VERSION, HOST_NAME, IP_ADDRESS, GRID_NAME, DATABASE_TYPE, DATABASE_LICENSE, DEVSTUDIO_ID, DEVSTUDIO_VERSION, USER_NAME, JOB_NAME, JOB_ID, DATE_SUBMITTED, USER_LOGON_LOGOFF, PROCESS_NAME

VALUE

Audited value that corresponds to the NAME value

AUDIT_ID

Cross-referenced value for the ID in the amp_audit table

SEQUENCE_NUM

Reference used in the event a NAME is longer than 255 characters
If a NAME exceeds the column width, a second record will be created and this value will be used to sequence the entries.



Fields in the amp_audit_action table

Field

Description and sample values

ID

Unique record identifier and primary key

ACTION_SEQ_NUM

Reserved for future functionality
Currently, the value is always 1.

ACTION

The audited action performed
Valid values: DATE_ACTIVATED, DATE_DEACTIVATED, DATE_DEPLOYED, DATE_UNDEPLOYED, DATE_INSTALLED, DATE_CONFIGURED, USER_LOGON, USER_LOGOFF, JOB_SUBMIT

ACTION_TIME

Time at which the action was performed
The format is YYYY-MM-DD HH:MM:SS.

ACTION_USER

User name on the account that performed the action

AUDIT_ID

Cross-referenced value for the ID in the amp_audit table