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 |
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: |
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 |
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 |
ACTION | The audited action performed |
ACTION_TIME | Time at which the action was performed |
ACTION_USER | User name on the account that performed the action |
AUDIT_ID | Cross-referenced value for the ID in the amp_audit table |
Comments
Log in or register to comment.