Mass Updating Contact Group

[craigles]

Hi,

Is it possible to MASS update services and hosts with a new contact group?
I've got one contact group assigned to about 500 services, and I need to move them to another contact group for alert purposes but I can't seem to find anyway of doing it besides visiting every service and that is going to take me a long long time.

Cheers,
Craig

[craigles]

Seems I should have done a search before posting, sigh - Sorry about that.
My query seems to be roughly the same as the one in this post - http://support.nagios.com/forum/viewtop ... =16&t=5814

If somebody could give me access to the beta of Nagios XI CCM it would be appreciated, and tell me if what I want to do can be achieved

Cheers,
Craig

[scottwilkerson]

Craig,

Available in this post
http://support.nagios.com/forum/viewtop ... eta#p25965

[craigles]

Hi Scott,

Thanks for that.
I had a quick look and I couldn't see exactly how I could do what I need to do.

Would you mind giving me a quick shove in the right direction please?
I just need to update all my hosts and services to go to a new contact group instead of the old one specified.

Cheers,
Craig

[scottwilkerson]

As of right now you cannot do a contact group, but you can bulk add/remove contacts

Configure -> CCM Beta -> Tools -> Bulk Modifications -> Remove a Contact From a List
or
Configure -> CCM Beta -> Tools -> Bulk Modifications -> Add a Contact to a List

[craigles]

Hi Scott,

Any plans on adding the functionality to perform that operation?
Is there anyway I can access the backend database and make the required changes there by sql and then regenerate the configs?

Cheers,
Craig

[mguthrie]

Hi Craig,

I'm the developer on the new CCM, and yes, we will add the ability to bulk edit contact groups to the new CCM, but it may not be ready before you need it.

How's your SQL ability? ; )

Config Database is: MySQL ->nagiosql

The contact groups and hosts are connected with by the relationship tables: tbl_lnkContactgroupToHost and tbl_lnkHostToContactgroup. A quick and safer way to do this reassignment would be to clear the relationships in these tables, and then move towards to using templates for the contact group assignments. I highly recommend making a backup of your XI install before attempting any mods to the database. We can talk you through the process, but it's sort of a "do at your own risk" scenario, and it depends on your SQL comfort level as well.

http://library.nagios.com/library/produ ... -nagios-xi