How to export the list of servers under monitoring from CA UIM operator console
Release : 20.3
Component : UIM - OPERATOR CONSOLE
Currently, there is no such option available in OC. However, if it helps, what you see in inventory is essentially the CM_COMPUTER_SYSTEM table in the UIM Database.
Every entry there is 1 master device (includes correlated devices into one) which are the devices that should be visible in inventory.
In the same way, you may query for other details including Robots, hubs etc as below:
--All robots:
select * from CM_NIMBUS_ROBOT
-- all non-hub-robots:
select * from CM_NIMBUS_ROBOT where is_hub = '0'
-- all hubs:
select * from CM_NIMBUS_ROBOT where is_hub = '1'
-- all Probes deployed on all robots, order by robot_id:
select * from CM_NIMBUS_PROBE order by robot_id
You can use the following to find any robot which has HNM for an origin:
select * from CM_NIMBUS_ROBOT where origin like '%HNM%'