Bulk import
Posted: Wed Nov 23, 2011 5:41 am
Hello,
We just did a fresh install of Nagios XI over a new installation of CentOS 64 bits, in a new virtual machine. The system is working properly, but now I need to add 1000 hosts to the system. I searched but I didn't found the proper manner to do it, everybody seems to have the same problem.
I tested the "bulk insert" wizard, but this don't introduce all the info that I need. It would be desirable that the bulk insert wizard would fill the 3 fields that come with it (name, description and addres) and would copy the rest of the info (parent, services...) from the host template, but it doesn't work, doesn't copy the info from the parent.
I have read also that I can insert hosts with the import config file option in the core config manager, but my question is: Do I need 1000 files (1 for every host) or Can I import in one file more than one host?
Is there any way to bulk import? If the only way is scripting sql query's, what query's do I need?
I don't understand why is so difficult realize this common task in a popular product like Nagios...
We just did a fresh install of Nagios XI over a new installation of CentOS 64 bits, in a new virtual machine. The system is working properly, but now I need to add 1000 hosts to the system. I searched but I didn't found the proper manner to do it, everybody seems to have the same problem.
I tested the "bulk insert" wizard, but this don't introduce all the info that I need. It would be desirable that the bulk insert wizard would fill the 3 fields that come with it (name, description and addres) and would copy the rest of the info (parent, services...) from the host template, but it doesn't work, doesn't copy the info from the parent.
I have read also that I can insert hosts with the import config file option in the core config manager, but my question is: Do I need 1000 files (1 for every host) or Can I import in one file more than one host?
Is there any way to bulk import? If the only way is scripting sql query's, what query's do I need?
I don't understand why is so difficult realize this common task in a popular product like Nagios...