Looking for Nagios Mysql Query with Contact Names

[mrochelle]

I'm looking for a mysql query to pull basic monitoring details, ( Host, Service, Notification Contact ) for each service and host monitor. If anyone has something close, I would appreciate it.
Thanks,
Marcus

[tmcdonald]

I wouldn't have anything off-hand since the database is so relational, but the REST API in XI 5 should be able to do what you want. Have you tried that? All the info is under the Help menu.

[mrochelle]

Yes, I spent some time reviewing the REST API but did not find a query that linked the monitor detail to the configured notification contacts for the monitor.

[ssax]

I don't have a SQL query for you but you should be able to get the information from this page:

Code: Select all

http://YOURXISERVER/nagios/cgi-bin/config.cgi

Let us know if that works for you.


Thank you

[mrochelle]

Outstanding! That works...Thank You!

[ssax]

No problem, are we okay to mark this as resolved and lock the topic?

[mrochelle]

Yes, definitely.