Server metadata.
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 |
COMMANDLINE |
varchar |
Command line directive used to start the server as a service (in-process) |
CPU |
varchar |
CPU type (Intel, ARM, etc) |
CPU_COUNT |
int |
# of CPUs |
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 ) |
CURR_TIME |
datetime |
Current server time |
DESCRIPTION |
nvarchar |
Server description |
DISK_AVAILABLE_MB |
float |
Disk available on server in MB |
DISK_TOTAL_MB |
float |
Disk total used in MB |
FRIENDLY_NAME |
varchar |
Friendly name of the server, e.g. "aps" is really Adaptive Processing Server |
ID |
int |
Primary key |
ISALIVE |
bit |
Is the Service running? |
ISAUDITING |
bit |
Is auditing enabled? |
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. |
ISDISABLED |
bit |
Is the service running? |
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 |
MEMORY_MB |
bigint |
How much memory is this server using? |
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 |
OS |
varchar |
What OS is installed where this server resides? |
PARENTCUID |
varchar |
Parent CUID of the folder to which the servers belong |
PARENTFOLDERCUID |
varchar |
Under what parent does the server live? |
PARENTID |
int |
The object's Parent ID, which could be an instance or folder or object package or publication. В Equivalent of SI_PARENTID |
PID |
int |
The process ID that hosts the server service. |
PRODUCT_VERSION |
varchar |
XI3 or BI4 product version this server is running |
REQUIRESRESTART |
bit |
Does the server require a restart? |
SERVER_KIND |
varchar |
What type of server is this? |
SIAHOSTNAME |
varchar |
SIA Hostname |
START_TIME |
datetime |
when did this server service start? |
STATUSINFO |
varchar |
Status information |
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 |
VERSION |
varchar |
version of the server |
See also