Bulk import

[estabviena]

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...

[lmiltchev]

estabviena,

Are you sure you got the right wizard? Here is the link to the Bulk Host Import Wizard (it is a customer-only download):

http://library.nagios.com/library/produ ... ort-wizard

We are not ready with the documentation, yet but we are working on it. On my test machine I was able to import properly all of the 3 fields (name, description and address) and the hostgroup relationship. The parent-child relationship did not transfer, so our lead developer will be looking at this issue.

Please, let us know if you have any more questions, ideas, etc. We appreciate any feedback! Thanks!

[estabviena]

Well, the parent relationship is for me the most interesting field. If it doesn't work in this wizard, is there anoher way to do a bulk import loading the field 'parent' ?

[jsmurphy]

You don't need to understand SQL for automating host imports (different story for users), I wrote a script to synchronize Nagios with our AD and VMware infrastructure... one day maybe I'll find the time to clean it up and share the love. But for now how I achieved this was create host files in the nagios/etc/import directory (You can have one host definition per file, or multiple, it doesn't matter) then use /usr/local/nagiosxi/scripts/reconfigure_nagios.sh to kick off the import process.

Part of the reason for Nagios lacking what you might consider core features (Native LDAP/AD auth, bulk changes/import management, etc) for the enterprise is that it's still quite young in terms of enterprise focus... previously it had always focused more internally on providing a rock solid flexible monitoring framework instead of raw features and trying to be all things to all people as IBM or HP's products tend to attempt. That's my personal take on it anyway, you will however find that the devs around these parts do take suggestions you make seriously... so if you have a good idea share it

[lmiltchev]

estabviena,

We are currently looking at the "parent-child relationship" issue and we will let you know when this is going to be fixed as soon as we can.

[lmiltchev]

estabviena,

The "parent-child relationship" issue has been fixed. I've just tested it. You can download the Bulk Host Import Wizard and see how it works.

http://exchange.nagios.org/directory/Ad ... rd/details