Table AUDIT_SUMMARY2XI3

AUDIT_DATE_TIME

datetime

Datetime of when the audit event took place

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.

DESKTOP_THREETIER_COUNT

int

Count of DESKI n-tier Connections

DESKTOP_THREETIER_SEC

int

Duration of DESKI n-tier connections (seconds)

DOC_RETRIEVED_COUNT

int

Count of DOCUMENT RETRIEVED events

DOC_RETRIEVED_SEC

int

Duration of DOCUMENT RETRIEVED events (seconds)

DOC_SAVED_COUNT

int

Count of DOCUMENT SAVED events

DOC_SAVED_SEC

int

Duration of DOCUMENT SAVED events (seconds)

DOCUMENTNAME

varchar

Name of the document (NOT USED)

EDITED_COUNT

int

Count of EDIT events

EDITED_SEC

int

Duration of EDIT events (seconds)

EVENT_ID

varchar

Audit Event ID (as its maintained in XI3 audit db)

EVENT_TYPE_DESCRIPTION

varchar

Audit Event description

EVENT_TYPE_ID

varchar

Audit Event Description ID

FOLDERPATH

nvarchar

Folderpath of the object being audited

FORMATTED_COUNT

int

Count of FORMAT APPLIED events

FORMATTED_SEC

int

Duration of FORMAT APPLIED events (seconds)

ID

int

Internal MetaMiner ID of the Audit Summary event

ISINSTANCE

bit

Is the object an isntance? В 0 = FALSE; Returns 1 = TRUE

LOVRTVRD_COUNT

int

Count of LOVs RETRIEVED events

LOVRTVRD_SEC

int

Duration of LOVs RETRIEVED events (seconds)

OBJECT_CUID

varchar

Object CUID upon which the audit event occurred

OBJECT_TYPE

varchar

Object type of the object

PAGERTRVD_COUNT

int

Count of PAGE RETRIEVED events

PAGERTRVD_SEC

int

Duration of PAGES RETRIEVED events (seconds)

PARENT_CUID

varchar

Parent CUID of the object (may or may not be a Folder object)

REFRESH_COUNT

int

Count of REFRESH events

REFRESH_SEC

int

Duration of REFRESH events (seconds)

REP_VIEW_FAIL_COUNT

int

Count of FAILED REP VIEWS

REP_VIEW_FAIL_SEC

int

Duration of FAILED REP VIEWS (seconds)

REP_VIEW_SUCCEED_COUNT

int

Count of SUCCESSFUL REP VIEWs

REP_VIEW_SUCCEED_SEC

int

Duration of SUCCESSFUL REP VIEWs (seconds)

REP2_VIEW_FAIL_COUNT

int

Count of FAILED REP VIEWS

REP2_VIEW_FAIL_SEC

int

Duration of FAILED REP VIEWS (seconds)

REP2_VIEW_SUCCEED_COUNT

int

Count of SUCCESSFUL REP VIEWs

REP2_VIEW_SUCCEED_SEC

int

Duration of SUCCESSFUL REP VIEWs (seconds)

REPORT_OPENED_COUNT

int

Count REPORT OPENED events

REPORT_OPENED_SEC

int

Duration REPORT OPENED events (seconds)

SCHED_FAIL_COUNT

int

Count SCHEDULE FAILED events

SCHED_FAIL_SEC

int

Duration SCHEDULE FAILED events (seconds)

SCHED_SUCCEED_COUNT

int

Count  SUCCEEDED events

SCHED_SUCCEED_SEC

int

Duration SCHEDULE SUCCEEDED events (seconds)

SELECTED_COUNT

int

Count SELECTED UNIVERSE events

SELECTED_SEC

int

Duration SELECTED UNIVERSE events (seconds)

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

UNIVERSENAME

varchar

Universe name related to the object being audited if application (NOT USED)

UNV_LIST_RTRVD_COUNT

int

Count of UNIVERSE LIST RETRIEVED events

UNV_LIST_RTRVD_SEC

int

Duration of UNIVERSE LIST RETRIEVED events (seconds)

UPDATEDUTCMILLIS

bigint

Time this audit record was created in milliseconds

USER_NAME

varchar

User name responsible for this audit action