Using a SQL Query in an Alert and Matching a String

[Former Member]

I've created an alert in 12.0.4 using a SQL Query and the field that I'm trying to match is a string. Originally the query returned multiple rows but when the alert still didn't fire, I modified the query WHERE clause to return only one row:

NAME RESPONSE

Are area lights working? No

My expression in the metric is RESPONSE. In the Monitor I'm matching a string equal to No. (Do I need double quotes around the matchvalue? Single quotes? No quotes?) The metric is in the 15min scan group, the role is xMII Developers and I'm in that role. The monitor alert string is ' = '. Both metric and monitor are active and I've subscribed to the monitor. Other alerts in the 15min scan group (all based on tag queries) are firing off properly.

Why is nothing showing up in the Alert Log?

David Macindoe

[agentry_src · Accepted solution]

David,

Did you figure out the answer? If not, I will try to find someone to address your question.

Mike