SQL query that gets the contacts of a service and/or host?

[riahc3]

Hello

Is there a SQL query that I can run that gets all the standalone contacts (their email addresses) related to a host and/or service? It should be able to also retrieve contacts that are nested in contact groups that are associated with the host and/or service.

[scottwilkerson]

Nagios Core by itself doesn't run any database.

It does have the following URL though that you can enumerate over objects like hostlist and servicelist

Code: Select all

/nagios/jsonquery.html