Under Managed Alerts, I created a new alert were the Trigger Condition is a "Custom SQL Alert (Advanced)" and the SQL condition is a "Custom Node Poller". However, I was not able to retrieve any data, even when the simplest queries were executed. I could not use SWQL due to the limited functions available. I created a support ticket and at the time of this post, the development team confirmed there is a bug in all releases. I was able to work around this issue by altering the query and using the "Custom Node Table Poller".
CUSTOM NODE POLLER (doesn't work)
SELECT CustomPollerAssignmentView.AssignmentName, CustomPollerAssignmentView.CustomPollerAssignmentID FROM CustomPollerAssignmentView
CUSTOM NODE TABLE POLLER (works)
SELECT CustomPollerStatusTable.FullLabel, CustomPollerStatusTable.CustomPollerAssignmentID, CustomPollerStatusTable.CompressedRowID FROM CustomPollerStatusTable
Using an INNER JOIN in the "Custom Node Table Poller", you can link back to the "Custom Node Poller" and therefore the CustomPollerAssignmentView.
SELECT CustomPollerStatusTable.FullLabel, CustomPollerStatusTable.CustomPollerAssignmentID, CustomPollerStatusTable.CompressedRowID FROM CustomPollerStatusTable
INNER JOIN CustomPollerAssignmentView CPAV ON (CustomPollerStatusTable.CustomPollerAssignmentID = CPAV.CustomPollerAssignmentID)
Hope this helps.
