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.
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.
You can optimize the query if you would like.