I am having a problem reporting the status of an interface in an email alert using the advanced alert engine. Looking at the columns in the Interfaces table, there is a column named Status, but this is just a numeric value. Next to those are the StatusLED, AdminStatusLED and OperStatusLED and those have text in them that say up, down, unknown, etc., but they are referencing an image file so they all end with a .gif. What I am looking for is a way to say "${Interfaces.FullName} is currently ${Interfaces.???}" and show the current status of the interface in text, not a number like what is in the Status field. I am sure I could figure out something using a SQL command and provide some logic in there but that seems like a lot of work for such a small request. Is anyone else having this issue?
