I want to create a group with all the Scalability Servers. How can I create a query to list all Scalability Servers?

Document ID : KB000018175
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

I want to create a group with all the Scalability Servers. How can I create a query to list all Scalability Servers?

 

Environment:                                          

CA Client Automation - All Version

 

Answer:

The query designer does not provide a specific parameter of type "Scalability Server" and to achieve it a customized query must be used when creating the query.

Please proceed as follows:

  1. Create a new Query of "Computer" type

    Figure 1

  2. In Query Designer click on « Advanced Argument»

    Figure 2

  3. In « Add Advanced Argument » select -Any- in the Table field and put the following line in the WHERE clause :

    select dis_hw_uuid from ca_server

    If the list must include only the remote Scalability Servers without the Domain Manager, use the following query:

    select dis_hw_uuid from ca_server where label not in (select label from ca_manager)

    Figure 3

  4. Click OK

This query returns the list of all Scalability Servers.