DX Infrastructure Manager

Expand all | Collapse all

In an alarm of snmpcollector, show Ip Address and Alias of an Interface

  • 1.  In an alarm of snmpcollector, show Ip Address and Alias of an Interface

    Posted 17 days ago
    Hi Everyone.

    I need capture the Ip address and alias of an interface when this interface present a down (alarm in USM).
    We have 1000 device in monitoring via snmpcollector and each interface correspond to an enlace principal or backup, that for the critical operation it's necessary show on the alarm the ip address and alias.



    I am using enrichment source via NAS probe on the field custom_1 for capture the alias, but I can't to capture the ip address for the interface.
    I know that the IP address is in this table CM_CONFIGURATION_ITEM_ATTRIBUTE, but to correlate in the query with the ci_id it does not allow because the ci_id is totally different.


    This is my query ----->

    select ci_name, ci_attr_value, dev_ip,ci_metric_id from cm_device (NoLock)
    a inner join cm_configuration_item (NoLock)
    b on a.dev_id = b.dev_id inner join CM_CONFIGURATION_ITEM_ATTRIBUTE (NoLock)
    c on b.ci_id = c.ci_id and c.ci_attr_key='IfAlias' INNER JOIN cm_configuration_item_metric (NoLock)
    d on c.ci_id = d.ci_id where ci_metric_id=?

    Where ci_mertic_id, comes from alarm.

    Anyone have any idea how to add the Ip of the interface in my query? I think the problem is ci_id which for aliases and for Ipv4address are different.
    Or if someone guides me on how to capture what I need.

    Best Regards.



  • 2.  RE: In an alarm of snmpcollector, show Ip Address and Alias of an Interface

    Broadcom Employee
    Posted 9 days ago
    The USM Details tab info is populated from CM_COMPUTER_SYSTEM and CM_COMPUTER_SYSTEM_ATTR

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------