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 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: RBA, PEER, ADAPTER, MODULE, DEV_STUDIO, DATA_REPOSITORY.
Entity_Name	Specific BMC Atrium Orchestrator component being audited
Grid_Name	The name of the grid on which the BMC Atrium Orchestrator component resides Note The BMC Atrium Orchestrator entity name CDP indicates the grid creation. Grid creation does not generate a separate entry.
Peer_Name	The name of the peer on which the BMC Atrium Orchestrator component resides.
GRID_ID	Identification number assigned to the grid on which the BMC Atrium Orchestrator component resides
PEER_ID	Identification number assigned to the peer on which the BMC Atrium Orchestrator component resides

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
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
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

Audit table information

On this page