I'm looking for a little bit of SQL query help. I have been working on some advanced alerts for UPS details. For my UPS systems I monitor input voltage, input frequency, percent load, battery capacity, and general faults.
What I would like to do is when one of my alerts is triggered and the emails go out, I would like to include details from the other UnDP's. For example, if an alert is triggered because a UPS is running on battery power, I would like to send out the input voltage and frequency so I can determine why the UPS is on battery right away.
From everything I have been reading I would need to do this via SQL queries in the message in order to pull variable info from multiple pollers. I am not the best at SQL management - took one course years ago, but I don't use it very often.
If anyone can offer any help I wold appreciate it. Unless there is a different way to do this that is "easier"?
Thanks in advance.
Edit: I just found this thread:
I will work through it and see what I can come up with...
