nelsonc0

Not sure what I done different, but created a new alert today with the same sql statement copy/pasted and it worked?

you could do a custom sql variable, and use the where clause would be a bit tricky but I think it would be doable.

That is much simpler than my way I think I used the custom pollers ciscoEnvMonTemperatureThreshold and ciscoEnvMonTemperatureStatusValue Comparing the status against the threshold. The only thing I would suggest is using the RawStatus column vs. the status column. They hold the same information for the most part, but if…

numeric status is the field you want (which is the raw status in the table)

Try this in your message ${SQL:select interfaces.interfacename from interfaces join nodes on nodes.nodeid = interfaces.nodeid join custompollerassignment as cpa on nodes.nodeid = cpa.nodeid where cpa.custompollerassignmentid = '${CustomPollerStatus.CustomPollerAssignmentID}'}

Can you just use do threshold less than 1 or more than 1? Null or empty is still less than 1. Assuming that any real threshold would be above >=1.