Is there any way to use an Alert Custom Property in an Alert Action? I've tried looking for it in the "Insert Variable" dialogue but I can't find it.
You probably also want to do this, to deal with cases where there is nothing in that property. be default if you query returns a null then Orion displays the whole query which makes alerts pretty ugly.
${SQL: SELECT isnull(Email,'None') FROM AlertConfigurationsCustomProperties WHERE AlertID = '${N=Alerting;M=AlertID}'}
I just double check my instance, looks like the answer is not with the GUI, but you could create a custom SQL variable to display it
Any advice on that custom SQL query? I'm a SQL novice, I'm afraid.
It's kind of a whole thing to get into, I'll try to circle back later on when I get some time.
I think I got it. Here's what I constructed:
${SQL: SELECT Email FROM AlertConfigurationsCustomProperties WHERE AlertID = '${N=Alerting;M=AlertID}'}
Anything there that looks wrong to you?
Perfect, thanks a bunch! I had no idea that you could put any kind of "isnull" function in there. That actually worried me a bit; this function solves that problem. Thanks for the help!
