Hello Everyone,
I would like to include the value for 'Condition Must Exist for More Than' in my alerts. But I can find a variable for this value, nor can I find the SQL table where it is stored. Can anyone help?
Thanks, Brent
I'm not sure either so you can either just type it manually in your alert (no variable) or you could use the down variable which will show how long it has been down for by the time you get the email.
It lives inside the giant block of XML inside orion.alertconfigurations.trigger, but its a bit of a chore to parse the XML and turn it into something easy to read. If you get really motivated you can find it with a few substring() and charindex() functions strung together and some case logic to handle alerts that don't have the box ticked.
