Nagios Support Forum

Posted: **Thu Apr 04, 2019 8:01 am**

Dear Support,

Could you please suggest how I can extract list of all available hosts groups/host/host + services or only services into CSV file.
Installed Version: 5.4.13

Thank you in advance

Posted: **Thu Apr 04, 2019 11:31 am**

There isn't a way to get them through the UI but you can get them out of the database with a command like the following

Code: Select all

echo 'select CONCAT(name1,",",name2) as "host,service" from nagios_objects where objecttype_id in (1,2) AND is_active=1 and name1 != "";'|mysql -pnagiosxi nagios

Nagios Support Forum

extract list of all available hosts in nagiosxi

extract list of all available hosts in nagiosxi

Re: extract list of all available hosts in nagiosxi