Is there a way to export NagiosXI tools data?

[xpertech]

Is there a way to export NagiosXI tools data?

[npolovenko]

Hello, @xpertech. I believe backup-restore should take care of that.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
Other than that you could probably dump them from one database and import to another but that is not something we support or tested in the past.

[xpertech]

Since the monitored hosts and services of the destination servers are owned by different departments, we need to offer a list of monitored hosts and services for different departments.

[scottwilkerson]

The common tools (not user specific) are in the nagiosxi database

Code: Select all

select * from xi_options where name='commontools';

[xpertech]

Is there a way to simply export monitored hosts & services list to a excel/csv file, or txt file?

[tgriep]

The following MYSQL query will create a csv file /tmp/hostservice.csv with a list of Host and Services that are running on the server.

Code: Select all

echo "select nagios.nagios_hosts.host_object_id, nagios.nagios_services.host_object_id, nagios_hosts.display_name, nagios_services.display_name from nagios.nagios_hosts inner join nagios.nagios_services on nagios.nagios_hosts.host_object_id = nagios.nagios_services.host_object_id;" | mysql -u root -pnagiosxi -B | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" >>/tmp/hostservice.csv

This should get you what you want.

[xpertech]

Hi tgriep,

The returned information of MYSQL query are not enough, we hope the csv file looks like the NagiosXI Tools returned information.

[tgriep]

Sorry, I do not have an SQL query that can gather all of the Host, Service, commands, etc. from the servers database and as far as I know, none exist.