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

book

Article ID: 18175

calendar_today

Updated On:

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:

Attachments

1558701893582000018175_sktwi1f5rjvs16pn4.gif get_app
1558701891624000018175_sktwi1f5rjvs16pn3.gif get_app
1558701889680000018175_sktwi1f5rjvs16pn2.gif get_app