How to create a dynamic group of ITCM scalability servers.
Client Automation (ITCM) -- any version.
Step 1: Create a new computer group.
Step 2: Provide a name for the new group.
Step 3: Select "..." to create a new ITCM query.
Step 4: Select "Computers" as the targeted return type.
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.
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)
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.
Step 8: Save the query with a meaningful name.
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.