Nagios Support Forum

Posted: **Mon Apr 22, 2019 10:54 am**

Hello,

I was wondering if there is an easy way to get a report of all child relationships (hosts) for a parent host. For example, I want to generate a list of every device (host) connected to a switch. All of the hosts are entered correctly but we have so many, I am trying to simply get a list of all child devices off a single switch. I tried using the Hypermap but we have too many devices.

Thank you,

Shane

Posted: **Mon Apr 22, 2019 3:04 pm**

This should do the trick(replace 'localhost' with the actual parent host):

Code: Select all

echo "select nagios_hosts.display_name from ((nagios_objects INNER JOIN nagios_host_parenthosts ON nagios_objects.object_id=nagios_host_parenthosts.parent_host_object_id)INNER JOIN nagios_hosts ON nagios_host_parenthosts.host_id = nagios_hosts.host_id) where nagios_objects.name1='localhost';" | mysql -uroot -pnagiosxi -Dnagios

Posted: **Mon Apr 22, 2019 3:20 pm**

Thank you for the code and I apologize for the following newbie question, but where do I run that from? The SSH console?

Posted: **Mon Apr 22, 2019 3:32 pm**

Yes, run it from the command line of the XI machine.

Posted: **Tue Apr 23, 2019 9:27 am**

Thank you so much! That worked perfectly!

Posted: **Tue Apr 23, 2019 9:55 am**

Glad to hear!

Nagios Support Forum

Report on child relationships

Report on child relationships

Re: Report on child relationships

Re: Report on child relationships

Re: Report on child relationships

Re: Report on child relationships

Re: Report on child relationships