I'm trying to set up some new email alerts and finding myself limited by the variables available in Orion Alert Manager based on the alert type. For instance, I am trying to send an alert when a node in a particular group member has a status of down. I wanted to include the State variable that is normally available in Nodes so the appropriate tech can respond, however this is not an option within Group Members. I was thinking this would be possible to get around with a custom SQL query, but I have never used SQL before and have no idea what the syntax should be or how it would work. Can anyone help?
