Conditional alert messages

prichertjda

I'm trying to collapse our alerts as much as possible, and thought I might try to do one alert, and then use the condition (critical, down, warning) to determine the html style to use. I'm just not sure how to code this. Essentially I'm just looking for something like if the status is critical, use the style "red", if it's warning use the style "orange"  Any help would be appreciated.

mesverrum

You could use the custom SQL variable and a case condition to populate the html font color.  It would be something like this (but definitely not actually this, I'm just winging this from memory)

<font color = {sql : select case when severity = 1 then 'red' when severity = 2 then 'orange' when severity = 3 then 'yellow' else 'black' end as color from alertconfigurations where alertid = ${alertid} } >