Hi there
I am starting to turn grey with this one. I have cerated a custom universal device poller to monitor mulitple psu's on a cisco7200 and have successfully imported in the web console as per the snap below.
What I now need is to be able to create an advanced alert triggered by a condition change in the status of the psu.

I have created the following trigger conditions which use the same values as the enumeration mapping values. Would this be correct? I did create a complex condition that reflects the status above named 'Shutdown' which did send a blank email to my inbox for test purposes only.

And finally - this is the issue cracking me up. I am trying to create the alert text but not having much luck. How can i translate what is being polled into message of the email alert using variables. I am not that hot on SQL and any attempts I have made just produce meaningless garbage. Any help would be appreciated.
