MicroStrategy ONE

List Cluster Servers statement

Lists all of the Intelligence Servers in the cluster.

Copy
LIST [ALL] 
 SERVERS IN CLUSTER;

Example

Copy
LIST ALL SERVERS IN CLUSTER;

ResultSet Columns

CLUSTERED_SERVER_STATUS: Server status, returned as an integer:

  • 1: Active

  • 2: Paused

  • 3: Stopped

NAME: Name of the server, returned as a string.

PORT_NUMBER: Server port number, returned as an integer.

PROTOCOL: Server protocol, returned as a string.

WORKLOAD: Workload of the server, returned as an integer.