Column Name |
Data Type |
Description |
|---|---|---|
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 |
CREATED |
datetime |
The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME |
CUID |
varchar |
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. |
DESCRIPTION |
varchar |
Description of the user |
EMAILADDRESS |
varchar |
Email address of the user |
FULLNAME |
varchar |
Fullname of the user |
ID |
int |
Globally unique ID of the user (MMDB) |
ISCONCURRENTUSER |
int |
If the user is a concurrent user, then = 1, otherwise = 0 |
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. |
ISENABLED |
bit |
If the user is enabled, then = 1, otherwwise = 0 |
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 |
ISNAMEDUSER |
int |
If the user is a named userd, then = 1, else =0 |
ISPASSWORDCHANGEALLOWED |
int |
Is the user allowed to change their password? |
ISPASSWORDEXPIRYALLOWED |
int |
Is the users passsword allowed to expire? |
ISPASSWORDTOCHANGEATNEXTLOGON |
int |
Is the user's password going to required to change at next logon? |
KIND |
varchar |
The type of the object, equivalent to SI_KIND in the CMS/Query Builder |
LASTLOGONTIME |
datetime |
Most recent time the user logged onto the BusinessObjects environment |
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 |
See also