Getting servers connected to the APS

All primary communication that occurs in Crystal Enterprise is transmitted through the APS. The APS only knows the existence of a server if the server has told it that it exists and has connected to the APS. Thus, when you query the APS for a list of all servers, it will return only those servers that have connected to it. Each server that is connected is represented in the APS by an InfoObject. The CrystalEnterprise.Server plugin gives this InfoObject its distinctive functionality and allows you to start, stop, enable, and disable the server; as well as retrieving metrics about the server itself. To retrieve a list of servers connected to the APS, including each APS in the cluster, use the following query:

Servers = IStore.Query("SELECT SI_ID, SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_PROGID='CrystalEnterprise.Server'");

This query uses the Server object's ProgId (CrystalEnterprise.Server) to retrieve all servers.

Note:    Unlike many other queries you may have seen so far, this query retrieves the server objects from the CI_SYSTEMOBJECTS table.

Next: Starting, restarting, and stopping a server.