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

Article Id: 18175
Status: Published
Updated On: 14-02-2018 07:15
Legacy Id: TEC613427
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>

    Figure 1

  2. In Query Designer click on « Advanced Argument»

    <Please see attached file for image>

    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)

    <Please see attached file for image>

    Figure 3

  4. Click OK

This query returns the list of all Scalability Servers.

Environment:

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

insert_drive_file 1558701893582000018175_sktwi1f5rjvs16pn4.gif
arrow_downward Download
insert_drive_file 1558701891624000018175_sktwi1f5rjvs16pn3.gif
arrow_downward Download
insert_drive_file 1558701889680000018175_sktwi1f5rjvs16pn2.gif
arrow_downward Download