I need to populate an advanced alert email with data from another table in the database. For example, I have an advanced alert on a custom MIB poller for an APC UPS. This alerts when the temp gets over 85 degrees in an IDF. When it triggers, I want it to send an email that says "IDF b28-1 is 87 Degrees" where "b28-1" is a value in ${Nodes.Closet} and the "87" is stored in ${CustomPollerStatus.Rate}
I can only seem to access data in the table holding the data that was alerted on.
How can I pull data from a different table in the database?