Mass changes to Service Alert Contact Group

[kubben]

We've brought in about 400 windows servers using the mass load from a csv file, based on a single configured windows server. unfortunately, all of the services on that sample host are sending service alerts to the wrong contact group for the 400 we brought in in this fashion. from looking through the forums here, i am guessing, a SQL change is the solution, but i'm not sure what DB or tables we need to alter. can someone point me to the DB and tables that contain the assigned contact group assigned to service alert settings, or better the actual SQL to change this?

i'm afraid we cannot go live as it stands now, and changing 6 - 8 services per host alert settings on 400 hosts isn't terribly inviting.

i do note, these settings over write template settings. i have tried that route.

k.

[scottwilkerson]

The Bulk modifications tool can handle this, you can find it in the 2012RC4 under Configure -> CCM -> Tools -> Bulk Modifications.
http://labs.nagios.com/2012/09/11/nagio ... blic-beta/

While this is still marked beta, all reports have come back positive

[kubben]

If we upgrade to a beta version, do we still receive support?

[scottwilkerson]

Yes, but please note that as always with beta releases there is the possibility that issues could arise, or items in the beta could get pulled before final release.

You should also be sure you have a backup before upgrading to the beta.

[kubben]

After chatting with co-workers, we'd rather wait for the stable release, but are still tasked with at least removing the current notification settings on all services and hosts, and switch to a template based notification setting.

would there be an easy way to remove all service and host notifications that are not inherited from a template? via sql or what not.

[scottwilkerson]

It may be possible via SQL+Apply configuration but I couldn't in short order tell what the SQL would be.