Page 1 of 1
Nagios XI export Host and Service checks
Posted: Fri Sep 20, 2019 6:40 am
by Astergiou
Hello
is there a way to export all host and service checks in an excel?
I need sysadmin team to check for missing service checks
thnak you
Re: Nagios XI export Host and Service checks
Posted: Fri Sep 20, 2019 7:34 am
by scottwilkerson
We don't have an excell way of doing it, you can either get the JSON from the API
Or you can get it via a mysql command like the following
Code: Select all
echo "select name1 as host, name2 as service from nagios_objects where is_active=1 and objecttype_id IN (1,2) ORDER BY host,service;"|mysql -pnagiosxi nagios
Re: Nagios XI export Host and Service checks
Posted: Fri Sep 20, 2019 7:41 am
by Astergiou
thank you
Re: Nagios XI export Host and Service checks
Posted: Fri Sep 20, 2019 8:07 am
by scottwilkerson
Astergiou wrote:thank you
No problem
Locking thread