Query to retrieve server status

server administration XI Server Discussion
1

Hi,

I have a requirement to query the CMS database and find the list of all servers with the server running status. I have tried from CI_Infoobjects7 but could only find the fields like CUID & ObjectName. I could not find Server status field. Also, objectname is in Hexadecimal format. It there a way to retrieve actual name of the server.

Tried searching in multiple forums, but could only get information on how to retrieve from query builder.

Thanks in advance.

Regards,
Sukesh

sukrav :india: (BOB member since 2008-01-29)

2

CI_INFOOBJECTS7 is a repository table, you won’t get anything useful from it.

To perform a CMS Query you either need to use an SDK or the Query Builder (http://server:8080/BOE/AdmnTools). The property that identifies the server running state is si_server_is_alive. The value is 0 if stopped and 1 if running. This will display the names of stopped servers:

select si_name from ci_systemobjects where si_kind = 'server' and si_server_is_alive = 0

joepeters :us: (BOB member since 2002-08-29)