Nagios xi export checks in excel

Astergiou · Post by **Astergiou** » Wed Nov 25, 2020 9:05 am

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

scottwilkerson · Post by **scottwilkerson** » Wed Nov 25, 2020 4:16 pm

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

Astergiou · Post by **Astergiou** » Fri Nov 27, 2020 5:13 am

We would like to export service check per host

scottwilkerson · Post by **scottwilkerson** » Mon Nov 30, 2020 8:43 am

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

Nagios Support Forum

Nagios xi export checks in excel

Nagios xi export checks in excel

Re: Nagios xi export checks in excel

Re: Nagios xi export checks in excel

Re: Nagios xi export checks in excel