One of the key goals I've been given for the year is to move Solarwinds from monitoring to proactive resolution , out of this i figured it would be useful to know which nodes have generated which alerts by numbers over a certain period. Reasoning is then I can highlight nodes that generate alerts but are fixed automatically by Solarwinds, this avoids issue nodes from flying under the radar because Solarwinds is doing its job well.
How do i link nodes to alerts and pull a history per node? Alerts seem to be setup in [dbo].[AlertDefinitions] but i dont see a column that links the alert definition to an alert fired against a node?
Ideally i'd like something like;
Device | Alert | # Triggers | Date range (i.e. week or month)
Just need the tables / views to look at, happy to build the SQL queries (I plan to store this data in another table for historical analysis)
Regards
Nigel
