How to create a dynamic group of ITCM scalability servers.

Document ID : KB000074889
Last Modified Date : 27/03/2018
Show Technical Document Details
Question:
How to create a dynamic group of ITCM scalability servers.
Environment:
Client Automation (ITCM) -- any version.
Answer:
Step 1: Create a new computer group.

User-added image

Step 2: Provide a name for the new group.

User-added image

Step 3: Select "..." to create a new ITCM query.

User-added image

Step 4: Select "Computers" as the targeted return type.

User-added image

Step 5: Choose "advanced argument".
Note: There are multiple ways of querying scalability servers.  This particular document will use an advanced argument and provide a SQL query.

User-added image

Step 6: Provide pseudo text (a label) for the query and be sure "any" is selected for the table.

Copy in this query text, if you want to return all scalability servers, including domain managers:
select dis_hw_uuid from ca_server

Copy in this query text, if you want to return all scalability servers, excluding domain managers:
select dh.dis_hw_uuid from ca_discovered_hardware dh inner join ca_server srv on dh.dis_hw_uuid=srv.dis_hw_uuid and dh.host_uuid not in (select host_uuid from ca_manager)

User-added image

Step 7: Optionally "Preview" the results to be sure they are as expected.
Note the "preview" function is limited to a maximum of 100 results.

User-added image

User-added image

Step 8: Save the query with a meaningful name.

User-added image

Step 9: Review the evaluation settings and press OK to create the new group.
Note: Avoid using "All Engines", and always set groups to be evaluated by a specific engine.  Also be sure to choose an appropriate evaluation interval.  As groups and queries build over the years, it's better to not be overzealous when choosing an evaluation interval that is too often.

User-added image