Column Name |
Data Type |
Description |
AUDIT_DATE_TIME |
datetime |
Audit date time of the audit action |
BASE_CREATED |
datetime |
Datetime the base document was created if this is an instance audit record |
BASE_CUID |
varchar |
CUID of the base document was created if this is an instance audit record. CUIDs are Cluster Unique Identifiers that uniquely identify an InfoObject, within a given cluster and also identify replicas or copies of an object across multiple CMS clusters. Because CUIDs are moderately lengthy strings they are less efficient to use and slower to query for. |
BASE_KIND |
varchar |
Object type of the base document was created if this is an instance audit record |
BASE_PARENTCUID |
varchar |
Parent CUID of the base document was created if this is an instance audit record |
BASE_REPORT |
nvarchar |
report name of the base document was created if this is an instance audit record |
CMSID |
varchar |
The actualy 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 |
DAY_OF_MONTH |
int |
Day of the month the audit action occurred |
DAY_OF_WEEK |
nvarchar |
Day of the week of the audit action |
DAYS_AGO |
int |
Days ago from today the audit action occurred |
DESKITHREETIERS |
int |
Count of the Deski ntier actions |
DESKTOP_THREETIER_SEC |
int |
Duration of Deski ntier actions |
DOC_RETRIEVED_SEC |
int |
Duration of Document Retrieved actions |
DOC_RETRIEVES |
int |
Count of Document Retrieved actions |
DOC_SAVED_SEC |
int |
Duration of Document Saved actions |
DOC_SAVES |
int |
Count of Document Saved actions |
DOCUMENTNAME |
varchar |
Document name of the audited document |
EDITED_SEC |
int |
Duration of edit actions |
EDITS |
int |
Count of edit actions |
EVENT_ID |
varchar |
Unique audit event ID |
EVENT_TYPE_DESCRIPTION |
varchar |
Event Description |
EVENT_TYPE_ID |
varchar |
Event Type Id |
FOLDERPATH |
nvarchar |
Folder path of the audited object |
FORMATS |
int |
Count of format actions |
FORMATTED_SEC |
int |
Duration of format actions |
HOUR_OF_DAY |
int |
Hour of the day of the audited action |
ID |
int |
ID |
ISINSTANCE |
bit |
Indicates whether this object is an instance В (scheduled object) or not; Instances are usually only stored in the DOCUMENTS or V_DOCUMENTS table/view. Instances are NOT captured in base tables such as CRYSTAL_DOCUMENTS, WEBIxx_DOCUMENTS, DESKI_DOCUMENTS |
LAST_USER_NAME |
varchar |
User name of the last person to have audited this object |
LOV_RETRIEVES |
int |
Count of LOV actions |
LOVRTVRD_SEC |
int |
Duration of LOV actions |
MONTH_DATE |
datetime |
Month date of the audit action |
MONTH_NUMBER |
int |
Month number audit event |
OBJECT_CUID |
varchar |
CUID of the audited object |
OBJECT_TYPE |
varchar |
TYPE of the audited object |
PAGE_RETRIEVES |
int |
Count of page retrieves |
PAGERTRVD_SEC |
int |
Duration of page retrieved action |
PARENT_CUID |
varchar |
Parent CUID |
QUARTER |
int |
Quarter of the audited event |
QUARTER_YEAR |
varchar |
Quarter-Year of the audited event |
REFRESH_SEC |
int |
Duration of refresh actions |
REFRESHES |
int |
Count of refresh actions |
REP_VIEW_FAIL_SEC |
int |
Duration of Report View Failed action |
REP_VIEW_SUCCEED_SEC |
int |
Duration of Report View Succeeded action |
REP2_VIEW_FAIL_SEC |
int |
Duration of Report View Failed2 action |
REP2_VIEW_SUCCEED_SEC |
int |
Duration of Report View Succeeded2 action |
REPORT_OPENED_SEC |
int |
Duration of report opens |
REPORT_OPENS |
int |
Count of report opens |
SCHED_FAIL_SEC |
int |
Duration of schedule failures |
SCHED_FAILURES |
int |
Count of schedule failures |
SCHED_SUCCEED_SEC |
int |
Duration of schedule succeeded |
SCHED_SUCCESSED |
int |
Count of schedule successes |
SELECTED_SEC |
int |
Duration of selected universes |
SELECTEDS |
int |
Count of selected universes |
SERVER_CUID |
varchar |
The server CUID from where the audit action was invoked |
SESSION_ID |
varchar |
Session ID of the user or system performing the audit action |
UNIVERSENAME |
varchar |
NOT USED |
UNV_LIST |
int |
Count of Universes listed events |
UNV_LIST_RTRVD_SEC |
int |
Duration of Universes listed events |
UNVLISTINGS |
int |
NOT USED |
UPDATEDUTCMILLIS |
bigint |
Time in milliseconds that this object was updated in the BusinessObjects CMS |
USER_NAME |
varchar |
User name of the last person to have audited this object |
VIEW_FAILURES |
int |
Count of view failure actions |
VIEW_FAILURES2 |
int |
Count of view failure2 actions |
VIEW_SUCCESSES |
int |
Count of view succeeded actions |
VIEW_SUCCESSES2 |
int |
Count of view succeeded2 actions |
YEAR |
int |
Year the audit action occurred |
See also