Hi guys,
I have a situation where an IC is appearing duplicated with a different origin, I need to find out which robot/probe is modeling this IC.
I found this KB "https://knowledge.broadcom.com/external/article?articleId=132991" and in it there is a query to check snmp devices, would it be possible to adjust the query to get the robo/probe using the IP as a filter? and so identify the origin of these CIs?
That was my test;
-- Returns the discovery result of SNMP protocol:
-- https://knowledge.broadcom.com/external/article?articleId=132991
select d.dev_name, d.dev_id, d.dev_ip, d.time_created, d.time_processed, cs.name as device_display_name, cs.cs_id as device_display_id, cs.origin as device_origin,
cs2.name as probe_robot_name, cs2.cs_id as probe_roobt_id, cs2.origin as probe_origin,
da.address as agent_address, da.hub as agent_hub
from cm_device d
left outer join cm_device d2 on d.dev_src_id = d2.dev_id
left outer join cm_computer_system cs2 on d2.cs_id = cs2.cs_id
left outer join cm_computer_system cs on d.cs_id = cs.cs_id
left outer join cm_discovery_agent da on cs.da_id = da.da_id
where d.dev_ip = '10.106.160.4'
order by d.dev_name, agent_hub, d.time_created desc;