Page 1 of 1
Nagios XI export checks in excel
Posted: Wed Nov 25, 2020 9:05 am
by Astergiou
Hello
as our sysadmin want to double check if we miss any check on our Nagios Infrastructure we would like a way to export all service checks that are in place on Nagios
thank you
Re: Nagios XI export checks in excel
Posted: Wed Nov 25, 2020 4:16 pm
by scottwilkerson
Which info are you looking for for the service checks? We have an API in XI that can export much of this, not in excel but in JSON
Re: Nagios XI export checks in excel
Posted: Fri Nov 27, 2020 5:13 am
by Astergiou
We would like to export service check per host
Re: Nagios XI export checks in excel
Posted: Mon Nov 30, 2020 8:43 am
by scottwilkerson
Astergiou wrote:We would like to export service check per host
You can get this in JSON from the
Help -> API Docs -> Objects Reference -> objects/service
Or from the CLI you can query the DB with a command like the following:
Code: Select all
echo "SELECT o.name1 as host_name, o.name2 AS service_description from nagios_objects o WHERE o.object_id NOT IN (SELECT service_object_id from nagios_servicegroup_members) AND is_active=1 AND objecttype_id=2;" | mysql -pnagiosxi nagios