Trying to do something that appears to be simple, but might not be.
We use our SNMP location field to describe the site a device is at. Our NOC wants to know who a remedy ticket should go to for each location. Sometimes its quite simple, there is a Remedy Group that corresponds to the site. But sometimes one site might not have IT people at it so another site watches over it.
So, what I was thinking of doing was creating a table that cross referenced every possible SNMP Location with the Remedy Group's name that takes care of that site. That way when the NOC receives a ticket, they know who to inform if needed.
So, just playing around, I created a new table in my Orion database called "Remedy" and it has two varchar variables; RemedyGroup and SNMPLocation. I put some dummy data in it and went to Alert Manager and created an alert for when a node goes down. I had it email me and as part of the body of the message I had:
${SQL:Select RemedyGroup From Remedy where SNMPLocation LIKE '${Location}'}
The only thing I get when I do this is a copy of this exact SQL statement in the body of the email.
Can I do this? ie: create a new table and reference it in an SQL statement? If so, what did I do wrong here? I tried using "=" instead of "LIKE" too, as well as a number of other things, but no luck.
Any clues as to where to go from here so that I can accomplish what I want?
