Hi there
This is probably an easy question but I want a Nagios view by hosts that have the most alerts? How can I order by that please? Or does it require me to run my own mysql queries on the database?
Incidentally the reason I want this is so I can remediate servers that cause most alerts, prioritising those that alert most frequently.
Many thanks
Nick
Seeing which hosts cause most alerts
Re: Seeing which hosts cause most alerts
Under Reports click 'Summary', then change the 'Report Type'.
Now, change the 'Report Type' to 'Top 25....' (pick hosts or services), and click 'Create Summary Report!'.
This will show you the most state changes. Nagios Core doesn't use SQL standard, so there shouldn't be any database to query.
Now, change the 'Report Type' to 'Top 25....' (pick hosts or services), and click 'Create Summary Report!'.
This will show you the most state changes. Nagios Core doesn't use SQL standard, so there shouldn't be any database to query.
Former Nagios Employee