Table SESSIONS

AUTHEN_METHOD

varchar

How do people authenticate in the system?

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

CONCURRENT

bit

Is the session of a concurrent logon?

CREATED

datetime

The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME

CUID

varchar

The unique ID of the object, but does not stay unique across environments (CMS/Query Builder equivalent of SI_ID )

FAILED_LOGON_COUNT

int

How many times did this session have a failed logon?

ID

int

Primary key

ISDELETED

bit

Indicates whether this object was deleted from the BusinessObjects CMS. В When set to "1", the object was deleted and MetaMiner keeps a "soft delete" record of its metadata.

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

KIND

varchar

The type of the object, equivalent to SI_KIND in the CMS/Query Builder

LAST_ACCESS

datetime

Last time the session was accessed

LAST_LOGON_TIME

datetime

Last time the user was logged on

LOGON_ALIAS

varchar

Alias for the logon

NAME

nvarchar

The name of the object, in many cases the equivalent of SI_ID in the CMS/Query Builder when referring to a base CMS object type (USERS, SEMANTICLAYER etc.)

OBJECTID

int

The SI_ID of the object as its known to the BusinessObjects CMS

PARENTID

int

The object's Parent ID, which could be an instance or folder or object package or publication. В Equivalent of SI_PARENTID

UPDATED

datetime

Datetime that this object was updated in the BusinessObjects CMS

UPDATEDUTCMILLIS

bigint

Time in milliseconds that this object was updated in the BusinessObjects CMS

USER_ID

int

User ID (SI_ID) of the user session