Get mapping of device inventory and its producing probe and robot

Document ID : KB000111708
Last Modified Date : 22/08/2018
Show Technical Document Details
Introduction:

sometimes decommissioned ip device still visible in USM and you don't know which robot / probe is source producing that device inventory data.

here is an example sql to get to know the map.

Environment:
UIM ANY version
Instructions:

Here is an example sql.

select a.origin, c.robot, a.name, b.probe_name, c.address from CM_COMPUTER_SYSTEM a
INNER JOIN CM_DEVICE b on b.cs_id = a.cs_id
INNER JOIN CM_NIMBUS_ROBOT c on c.dev_id = b.dev_src_id
ORDER BY origin,robot,name
 

Unfortunately, niscache based agent-less probes are displayed as "niscache"