Column Name |
Data Type |
Description |
|---|---|---|
APPLICATION_CUID |
varchar |
CUID of the application category from where the audited event occurred |
AVG_CONCURRENT_SESSCOUNT |
int |
Concurrent number of sessions at the time at which the audit action took place |
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 |
DAY_OF_WEEK |
nvarchar |
Day of the week |
DAYS_AGO |
int |
How many days ago from today the user logged on |
HOUR_OF_DAY |
int |
Hour of the day the logon occurred |
LOGOFF_TIME |
datetime |
Time of logoff (NOTE: Sessions could timeout and skew session duration data) |
LOGON_TIME |
datetime |
Time of logon |
MAX_CONCURRENT_SESSCOUNT |
int |
Maximum number of concurrent sessions during the time of the session logon/logoff |
MAX_DATE |
datetime |
Maximum (latest point in time) for the given session |
MIN_CONCURRENT_SESSCOUNT |
int |
Minimum number of concurrent users over the course of this session |
MONTH_DATE |
datetime |
Month date of the session |
MONTH_NUMBER |
int |
Month number of the session |
QUARTER |
int |
Quarter of the session |
QUARTER_YEAR |
varchar |
Quarter year of the session |
SERVER_CUID |
varchar |
CUID from where the session was logged |
SESSION_DURATION_MIN |
int |
Duration of the session in minutes |
SESSION_ID |
varchar |
ID of the session that was tied to this event (user or system) |
UPDATEDUTCMILLIS |
bigint |
Time in milliseconds that this object was updated in the BusinessObjects CMS |
USER_CUID_14 |
varchar |
NOT USED |
USER_NAME |
varchar |
Name of the session user |
YEAR |
int |
Year number |
See also