On 16 Sep 2009, at 13:18, Andrew Hall wrote:
We're conducting a thorough review of our monitoring and I need to be running this query multiple times over the upcoming weeks.
It just so happens that I am working in this part of the code at the moment.
There is a very hairy piece in SQL in /usr/local/nagios/lib/Opsview/ Host.pm in list_resolved_services. This takes, for a single host, all the services associated with the host and all the services associated via the host templates too (and the exceptions, and the timed exceptions, etc)
This SQL is what nagconfgen uses to generate the list of services to check for a host.
With a bit of adaptation, you could run a similar piece of SQL to return back the plugin and arguments used. Good luck!
Ton _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
