Nagios XI export Host and Service checks

[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

[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

[Astergiou]

thank you

[scottwilkerson]

thank you

No problem

Locking thread