2 Replies Latest reply on Aug 2, 2016 8:43 AM by v793389

    How to have a trap alarm query the DB for more info b4 emailing alert

    mfregeau

      Hello fellow Solarwinders.

       

      I have this situation where I created an alarm that emails a bunch of information when a trap saying BGP neighbor was lost/found.

       

      My collegues are asking to have additional information in the email, information that the trap does not supply.

       

      The trap supplies the IP address of the interface, My collegues want to have the interface ID (ie:Gi0/1) and the interface alias (description).

       

      How can I have the alarm search for that information in the database and include it in the email being sent to our group.

       

      More details can be sent as requested.

       

      Thank you in advance for your time.

        • Re: How to have a trap alarm query the DB for more info b4 emailing alert
          mfregeau

          OK, I found some more information that allowed me to go further with this project, but I'm stuck again.

           

          Here is my query:

          ${SQL:SELECT NodeIPAddress.InterfaceIndex, Interfaces.Caption
          FROM [dbo].[NodeIPAddress] ON ospfNbrIpAddr=NodeIPAddress.IPAddress
          INNER JOIN [dbo].[Interfaces] ON Interfaces.InterfaceID = NodeIPAddress.InterfaceIndex}

           

          Here is the trap message:

          Received Time:6/11/2015 10:21:13 AM

          Source:10.111.246.44(uxxxxxxxxxxxxx)

          Community:$XXXXXXX

          Variable Bindings

          ospfRouterId:= 10.111.246.44

          ospfNbrIpAddr:= 10.110.113.16

          ospfNbrAddressLessIndex:= 0

          ospfNbrRtrId:= 10.111.248.95

          ospfNbrState:= down(1) (1)

          snmpTrapOID:= OSPF-MIB:ospfTraps.0.2 (1.3.6.1.2.1.14.16.2.0.2)

          sysUpTime:= 12 days 15 hours 40 minutes 48.64 seconds (109324864)

          experimental.1057.1.0:= 10.111.246.44

          snmpTrapEnterprise:= OSPF-MIB:ospfTraps (1.3.6.1.2.1.14.16.2)

           

          So I am trying to do a search with the IP in the variable "ospfNbrIpAddr".   Anyone can tell me what I'm doing wrong?