I wrote this report, which lists active advanced alerts, along with information about the host and such. Whenever I atttempt to view this through an account with a limitation applied, I get the following: Incorrect syntax near the keyword 'Where' select NODES.CAPTION, NODES.STATUSLED, NODES.PRIMARY_ROLE...

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...

I was reading several post and found some info about using Advanced SQL statements with the advanced Alert engine to use when monitoring UPS'. All of those post have proven to be extremely helpful but I am having a problem with one statement and I can not figure this out and I am curious if someone...

No the only thing that the SQL Statement will return is a single number (like the most recent syslog ID) I wonder if they have setup the sql statement to only return a single value.