I have multiplication in my swql statement. When I include swql statement in snmp trap trigger action, the statement does not executes. the trap has statement string instead of value.
Here is what my trigger action looks like
${N=SWQL;M=SELECT ((a.InErrorsThisHour / a.InBandwidth ) * 100 ) from Orion.NPM.Interfaces a}
when executed I see following value in the trap: ${N=SWQL;M=SELECT ((a.InErrorsThisHour / a.InBandwidth ) * 100 ) from Orion.NPM.Interfaces a.}
instead of actual value. If I am to modify statement like this:
${N=SWQL;M=SELECT a.InErrorsThisHour, a.InBandwidth from Orion.NPM.Interfaces a} the snmp trap has actual values for both variables
Has any one seen this issue with trigger action and how was it resolved?