Nagios Support Forum

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

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.