Skip to Content
0
Jun 07, 2017 at 03:46 PM

List the Services belonging to a BO Server

1174 Views

Hi

I want to list the Services belonging to a BO Server, the same list that we can see from the "Edit common services" in the CMC.

For example, the services belonging to node.Anaysis server are:
BEx Web Applications Service
Multi Dimensional Analysis Service
TraceLog Service

I hace the SELECT to list the servers, but I need also the list of Services hosted by every Server:

SELECT SI_NAME, SI_KIND, SI_SERVER_IS_ALIVE, SI_DISABLED, SI_SERVER_KIND, SI_FRIENDLY_NAME, SI_EXPECTED_RUN_STATE FROM CI_SYSTEMOBJECTS WHERE SI_KIND= 'SERVER'

I am using the Java SDK and the Query builder.

thanks in advance.

Eusebio Martinez