Advanced Alert w Custom Poller Table (compare 2 values w desc)

douglasmauro

We're using a poller table and trying to compare 2 values in the table

if column_x != column_y then alert: ${my_label} is bad

column_x == shproContactCurrentValue

column_y == shproContactNormalValue

Is this possible in current release? I can't find an easy way to do this?.?

2013-11-07_0945.png

Find more posts tagged with

npm

udp

Alerts

Accepted answers

JiriPsota

Create one more custom poller that will poll the labels. To get the Label in TriggerAction use query: (only change the poller name in query)

${SQL:select cs.Status from CustomPollers cp JOIN CustomPollerAssignment ca ON(cp.CustomPollerID=ca.CustomPollerID) JOIN CustomPollerStatus cs ON (ca.CustomPollerAssignmentID=cs.CustomPollerAssignmentID) where cp.UniqueName='CustomPollerLabel' and ca.NodeID=${NodeID} and cs.RowID=${RowID}}

All comments

JiriPsota

In your custom table poller use one column as polled OID and the second column as Label. Then you can in advanced alert compare Value with Label.

douglasmauro

Great idea but then when it fails, how will we know which one was triggered? We need the label as well

JiriPsota

Create one more custom poller that will poll the labels. To get the Label in TriggerAction use query: (only change the poller name in query)

douglasmauro

That worked like a charm. Many thanks!