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

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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
   
   

   <Please see attached file for image>

   
   
   
2. In Query Designer click on « Advanced Argument»
   
   

   <Please see attached file for image>

   
   
   
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)

   <Please see attached file for image>

   
   
   
4. Click OK

This query returns the list of all Scalability Servers.

Environment

Release: UASIT.99000-12.8-Asset Intelligence
Component: