In this recipe, we'll explore some simple applications of the NDOUtils database by trying out some queries and changing one of them into both a simple daily e-mail in Perl and also into a PHP-based RSS feed.
This recipe assumes that you have NDOUtils already installed and that your Nagios Core 4.0 or higher server is monitoring at least a few hosts and services so that the queries we try actually return some data. You should also have some means of executing MySQL queries on the database server. The
mysql(1) command-line client will work just fine; a web-based tool such as
phpMyAdmin might make the data a little easier to explore.
We can explore some queries against the NDOUtils databases as follows:
Retrieve the content and date/time of the latest 10 notifications:
mysql> SELECT start_time, long_output FROM nagios_notifications ORDER BY start_time DESC LIMIT 10;
Retrieve the content and date/time of the latest 10 host or...