Bulk loading host and services?

[TSCAdmin]

I was wondering if there was a way that I could bulk load host and server configs into Nagios XI? I have approximately 1200 hosts, each with 12 standard service checks. Obviously, I'd rather not have the servers entered by hand if we can do it in bulk.

Two options immediately come to mind:
1) Writing the mySQL insert statements directly (in which case I have to figure out the database schema (with mySQL workbench) and the syntax used for record insertion (with mySQL query analyzer)).
2) Using the "Nagios Core Configuration Import" procedure. I'm not entirely certain of using that interface for that quantity of hosts and services (14,400).

Are there any options I'm missing?

[tonyyarusso]

2) Using the "Nagios Core Configuration Import" procedure. I'm not entirely certain of using that interface for that quantity of hosts and services (14,400).

This *should* work actually - give it a try. There's also a configuration import prep tool in XI that will do some sanity checks / formatting for you before you pass it into that part.

[aaldrich]

2) Using the "Nagios Core Configuration Import" procedure. I'm not entirely certain of using that interface for that quantity of hosts and services (14,400).

This *should* work actually - give it a try. There's also a configuration import prep tool in XI that will do some sanity checks / formatting for you before you pass it into that part.

Where can I find this Nagios Core Configuration Procedure and the configuration import Prep Tool in XI?

We are developing scripts to deploy VMs in Vsphere and would like to add newly deployed hosts automatically to nagios for monitoring
as an ongoing process and also delete them from nagios when decommissioned

Suggestions?

[mmestnik]

Start another topic(or find the topic already started) for the NagiosXI automation stuff, though this can be done and there is some bits of pointers floating around.

As for your import it's all documented in our Nagios Library linked off our site nagios.com.

[Box293]

How did you go with the bulk import?