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 Some content is unavailable due to permissions. component being audited, user login, process scheduled RBA, PEER, ADAPTER, MODULE, DEV_STUDIO, DATA_REPOSITORY, USER, JOB
Entity_Name	Specific the Some content is unavailable due to permissions. component, user name associated with login, process scheduled
Grid_Name	Name of the grid on which the Some content is unavailable due to permissions. component resides or the process is scheduled to run Note: The Some content is unavailable due to permissions. entity name CDP indicates the grid creation. Grid creation does not generate a separate entry.
Peer_Name	Name of the peer on which the Some content is unavailable due to permissions. component resides or the process is scheduled to run
GRID_ID	Identification number assigned to the grid on which the Some content is unavailable due to permissions. component resides or the process is scheduled to run
PEER_ID	Identification number assigned to the peer on which the Some content is unavailable due to permissions. 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

Audit table information

On this page