Table AUDIT_SUMMARY2

Provides the equivalent of ADS_EVENT data specific to BI4 but also includes denormalized fields found in ADS_EVENT_DETAIL table.

Column Name	Data Type	Description
ACTION_ID	varchar	The ACTION_ID of the audit event, useful when determing several events clustered into a single user or systemaction
AUDIT_DATE	datetime	The date (without time) of when the audit event occurred
AUDIT_DATE_TIME	datetime	The date and time of when the audit event occurred
CMSID	varchar	The actual name of the CMS host machine without the port number, if used. This is used in conjunction with OBJECTID or CUID to uniquely identify an object across environments.
CREATE_COUNT	int	Count of CREATE events
CREATE_MS	bigint	Duration of CREATE events
DELETE_COUNT	int	Count of DELETE events
DELETE_MS	bigint	Duration of DELETE events
DELIVER_COUNT	int	Count of DELIVER events
DELIVER_MS	bigint	Duration of DELIVER eventts
EDIT_COUNT	int	Count of EDIT events
EDIT_MS	bigint	Duration of EDIT events
EVENT_ID	varchar	The Event ID of the event. Equivalent to ADS_EVENT.EVENT_ID
EVENT_TYPE_NAME	varchar	Event description of the audited event
EVENTS_COUNT	int	Count of events (always 1)
FOLDER_CUID	varchar	Folder CUID of the object upon which an audit event occurred
ID	int	MetaMiner internal unique ID
ISINSTANCE	bit	Is the object an isntance? В 0 = FALSE; Returns 1 = TRUE
MAX_DATE	bigint	The most recent time an action was performed on a given object
MODIFY_COUNT	int	Count of MODIFIED events
MODIFY_MS	bigint	Duration of MODIFIED events
OBJECT_CUID	varchar	Object CUID upon which the audit event occurred
OBJECT_NAME	nvarchar	Object Name upon which the audit event occurred
OBJECT_TYPE	varchar	Object type of the object
PAGE_RETRIEVED_COUNT	int	Count of PAGES RETRIEVED events
PAGE_RETRIEVED_MS	bigint	Duration of PAGES RETRIEVED events
PARENT_CUID	varchar	Parent CUID of the object (may or may not be a Folder object)
PROMPT_COUNT	int	Count of PROMPTS events
PROMPT_MS	bigint	Duration of PROMPT events
REFRESH_COUNT	int	Count of REFRESH events
REFRESH_MS	bigint	Duration of REFRESH events
RETRIEVE_COUNT	int	Count of RETRIEVE events
RETRIEVE_MS	bigint	Duration of Retrieve events
RUN_COUNT	int	Count of RUN events
RUN_MS	bigint	Duration of RUN events
SAVE_COUNT	int	Count of SAVE events
SAVE_MS	bigint	Duration of SAVE events
SEARCH_COUNT	int	Count of SEARCH events
SEARCH_MS	bigint	Duration of SEARCH events
SERVER_CUID	varchar	Server CUID from which this audit event occurred (APS, job server, etc)
SESSION_ID	varchar	Session ID linked to the user/system session that caused this event to occur; Joins back to AUDIT_SESSIONS table
STATUS_ID	int	Status ID of the evnet
UPDATEDUTCMILLIS	bigint	Time this audit record was created in milliseconds
USER_CUID	varchar	User CUID of the user responsible for making this event occur
USER_NAME	varchar	User Name of the user responsible for making this event occur
VIEW_COUNT	int	Count of VIEW events
VIEW_MS	bigint	Duration of VIEW events