0 Replies Latest reply on Jul 17, 2018 3:57 PM by juanflores

    Custom SQL Query to SNMP Trap

    juanflores

      Hi,

       

      I created an Custom SQL alert in NPM and I configured NPM to email me when the alert triggers. Now, I'm trying to configure NPM to send me a SNMP Trap when the alert triggers, but I have no idea how to pass the SQL field values to the SNMP trap so that I can get them in my SNMP Trap receiver.

       

      To get the values using the email method I use something like

       

      ${SQL:select Pkid from VoipCallDetailsAlert where ID = ${VoipCallDetailsAlert.ID}}

       

      to get a SQL field value in the email, but I have no idea how to set that in the SNMP Trap template so that I can get that value in the SNMP Trap. How can that be done?

       

      Usually I use stuff like "${N=SwisEntity;M=DisplayName}" in the SNMP Trap template so I can get alert values, but I'm not sure what to do with custom SQL values.

       

      Thank you