Method to extract all alerts mapped to all nodes?

aidanall

All,

I'm attempting to extract all alerts mapped to all nodes, similar to the "All alerts this object can trigger" widget, except for everything in the system as a CSV or similar.  However, I'm having difficulty finding the best way to get the information.  The web reports tool only allows me to search for alerts on a specific object, not all objects.  And using Hubble doesn't present me with the backend query used to fetch that data.

I then tried extracting the information from the database and devised this query which is close to what I want:

SELECT AlertObjects.RelatedNodeCaption, AlertConfigurationsView.Name
FROM [dbo].[AlertObjects]
LEFT JOIN AlertConfigurationsView ON AlertConfigurationsView.AlertID = AlertObjects.AlertID
ORDER BY AlertObjects.RelatedNodeCaption

However, there appears to be a limitation as to how comprehensive the AlertObjects table is, as it only indicates 15 alerts mapped to a node for which there are 51 alerts listed in the GUI.

Any guidance is appreciated.

Thank you in advance!

monitoringlife

There is not a relation between alerts and nodes like many (most?) monitoring tools.  There is also a defect about the 'all alerts this object can trigger' that is not showing all alerts.

Your best bet is to write a query/report that will tell you all alerts that node has triggered at least once (from the alert history).