Get mapping of device inventory and its producing probe and robot

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

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.

UIM ANY version

Here is an example sql.

select a.origin, c.robot,, 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"