MicroStrategy ONE

List Server Properties statement

Lists properties of Intelligence Server in the specified machine. If licensing information cannot be obtained, only the machine name, IP address, Intelligence Server version, and server status (such as Up or Down) are returned.

Copy 
LIST [ALL] PROPERTIES FOR SERVER "machine_name" [PORT 
 "port_number"] [LOGIN "login" [PASSWORD "password"]];

where:

  • SERVER "machine_name" is the network name of the machine running Intelligence Server, of type string.

  • PORT "port_number" is the port number used to connect to the machine, of type numeric.

  • LOGIN "login" is the login of the user used to connect to the machine, of type string.

  • PASSWORD "password" is the password of the user, of type string.

Example

Copy 
LIST PROPERTIES FOR SERVER "d_smith" LOGIN 
 "dsmith" PASSWORD "dsmpass;

ResultSet Columns

LIST ALL PROPERTIES FOR SERVER

  • IP_ADDRESS: The IP address of the Intelligence Server machine, returned as a string.

  • NAME: The name of the Intelligence Server machine, returned as a string.

  • SERVER_STATE: The state of Intelligence Server, returned as a string/integer:

    • 3000: Up

    • 3001: Down

  • VERSION: The version of Intelligence Server, such as "9.0.300.163." Returned as a string.

LIST ALL PROPERTIES FOR SERVER

  • CONTRACT_ID: The contract ID associated with the server, returned as a string.

  • DESKTOP_ANALYST_NAMED_USERS: The users using an Analyst license on Intelligence Server, returned as a string.

  • DESKTOP_ARCHITECT_NAMED_USERS: The users using an Architect license on Intelligence Server, returned as a string.

  • DESKTOP_DESIGNER_NAMED_USERS: The users using a Developer  license on Intelligence Server, returned as a string.

  • IP_ADDRESS: The IP address of the Intelligence Server machine, returned as a string.

  • ISERVER_CPU_USED: The number of CPUs used by the server, returned as a string.

  • ISERVER_MAX_NAMED_USERS: The maximum number of named users allowed by the license, returned as a string.

  • LICENSE_KEY: The license key associated with the server, returned as an integer.

  • LICENSE_KEY_ISSUE_DATE: The date the license key was issued, returned as a string.

  • MAXIMUM_NUMBER_OF_CPUS_ALLOWED: The maximum number of CPUs that Intelligence Server is allowed to use by the license, returned as a string.

  • NAME: The name of the Intelligence Server machine, returned as a string.

  • PORT_NUMBER: The port number associated with the server, returned as an integer.

  • SERVER_STATE: The state of Intelligence Server, returned as a string/integer:

    • 3000: Up

    • 3001: Down

  • SOFTWARE_LICENSE_AGREEMENT: The software license agreement associated with the server, returned as an integer.

  • VERSION: The version of Intelligence Server, such as "9.0.300.163." Returned as a string.

  • WEB_ANALYST_NAMED_USERS: The users using a Web Analyst license on Intelligence Server, returned as a string.

  • WEB_PROFESSIONAL_NAMED_USERS: The users using a Web Professional license on Intelligence Server, returned as a string.

  • WEB_REPORTER_NAMED_USERS: The users using a Web Reporter license on Intelligence Server, returned as a string.

  • WEB_UNIVERSAL_ANALYST_NAMED_USERS: The users using a Web Universal Analyst license on Intelligence Server, returned as a string.  

  • WEB_UNIVERSAL_PROFESSIONAL_NAMED_USERS: The users using a Web Universal Professional license on Intelligence Server, returned as a string.  

  • WEB_UNIVERSAL_REPORTER_NAMED_USERS: The users using a Web Universal Reporter license on Intelligence Server, returned as a string.