UMP Group .... Grouping by Hub

Document ID : KB000094830
Last Modified Date : 08/05/2018
Show Technical Document Details
Question:
How do I wet up my UMP groups such that all robots attached to a given hub are in that group? In one of our domains, I use Origin, which includes the hub name. But in the other, Origin often equals the domain name.
Environment:
UIM 8.51
Answer:
You can try using the following SQL query as a SQL filter for the USM group.
select dv.cs_id from CM_DEVICE dv
inner join CM_NIMBUS_ROBOT cnr on cnr.dev_id = dv.dev_id
where cnr.hub='<HUB NAME>'

Please change <HUB NAME> to the hub you would like.

NOTE:
You can optimize the query if you would like.