DX Unified Infrastructure Management

 View Only
  • 1.  Duplicate devices with different origins

    Posted Dec 01, 2021 08:40 AM
    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;


  • 2.  RE: Duplicate devices with different origins

    Broadcom Employee
    Posted Dec 01, 2021 09:28 AM
    S_QOS_DATA maybe the best table to query.
    select * from S_QOS_DATA where host = '<device ip address>'


  • 3.  RE: Duplicate devices with different origins

    Posted Dec 01, 2021 12:06 PM
    Hi David,

    The S_QOS _DATA table includes a list of Robos, QOS and targets, it does not show the probe responsible for modeling a CI.

    Right ?


  • 4.  RE: Duplicate devices with different origins

    Broadcom Employee
    Posted Dec 01, 2021 01:59 PM
    It does contain the probe.
    SELECT TOP 1000 [table_id]
    ,[ci_metric_id]
    ,[qos_def_id]
    ,[created]
    ,[checksum]
    ,[qos]
    ,[source]
    ,[target]
    ,[host]
    ,[origin]
    ,[robot]
    ,[probe]
    ,[r_table]
    ,[h_table]
    ,[v_table]
    ,[sampletime]
    ,[samplevalue]
    ,[samplemax]
    ,[nim_origin]
    ,[modifier]
    ,[samplerate]
    FROM [UIM92].[dbo].[S_QOS_DATA]


  • 5.  RE: Duplicate devices with different origins

    Posted Dec 06, 2021 07:38 AM
    Hi David,

    Actually I was thinking about using another table, because the probe responsible for model the IC probally is not configured to generated QoS for it, and it won't be in the S_QOS_DATA.

    Thanks.


  • 6.  RE: Duplicate devices with different origins

    Broadcom Employee
    Posted Dec 06, 2021 09:19 AM
    Sorry, no table with that info.
    If 'IC' is a probe then:
    Is there method to pull a report of all the robots with a specific probe deployed to it?
    Article Id: 228321
    https://knowledge.broadcom.com/external/article?articleId=228321