extract list of all available hosts in nagiosxi

[qtg_tech]

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

[scottwilkerson]

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