I want to create a group with all the Scalability Servers. How can I create a query to list all Scalability Servers?
CA Client Automation - All Version
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:
- Create a new Query of "Computer" type
- In Query Designer click on « Advanced Argument»
- 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)
- Click OK
This query returns the list of all Scalability Servers.