Provides session-level information as its captured by both the SAP BusinessObjects XI3 and BI4 auditing system.
Column Name |
Data Type |
Description |
|---|---|---|
APPLICATION_CUID |
varchar |
The application CUID related to the user session being audited (only relevant ????????).
|
AVG_CONCURRENT_SESSCOUNT |
int |
Count of the average number of sessions at the time of which the current SESSION_ID was active (used to measure concurrency during any given session/period) |
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. |
ID |
int |
The unique ID of the audit session (internal to MetaMiner, not related to BOBJ auditing) |
LOGOFF_COUNT |
int |
Count of LOGOFF events |
LOGOFF_MS |
bigint |
Duration of LOGOFF events |
LOGOFF_TIME |
datetime |
Time at which the user/session logged off or timed out from the system |
LOGON_COUNT |
int |
Count of LOGON events |
LOGON_MS |
bigint |
Duration of LOGON events |
LOGON_TIME |
datetime |
Logon time of the user |
MAX_CONCURRENT_SESSCOUNT |
int |
Max number of concurrent sessions for the duration of a particular session (SESSION_ID) |
MAX_DATE |
datetime |
Max date time of the session |
MIN_CONCURRENT_SESSCOUNT |
int |
Min number of concurrent sessions for the duration of a particular session (SESSION_ID) |
SERVER_CUID |
varchar |
The server CUID responsible for the session (useful to determine CMS.exe session load balancing) |
SESSION_DURATION_MIN |
int |
Duration of the session |
SESSION_ID |
varchar |
Unique ID of the session (as its maintained by BusinessObjects audit subsystem) |
UPDATEDUTCMILLIS |
bigint |
Update time of the AUDIT_SESSION record |
USER_CUID |
varchar |
User CUID of the audit user |
USER_NAME |
varchar |
User name of the audit user |
See also