Page 1 of 1

Mass change notification interval

Posted: Wed Jan 04, 2012 10:51 am
by jon.bilderback
I would like to modify the notification interval from 1 hour, to 12 hours on all of the hosts and services.
I think someone else was asking about this, but couldn't find it in a search.
Has anyone figured out a way to do this?

Thanks

Re: Mass change notification interval

Posted: Wed Jan 04, 2012 11:42 am
by scottwilkerson
We are going into undocumented territory, so make sure you have a backup....

However you should be able to do the following, I did this on my test machine without problems. If you changed the mysql password you will need to change it after the -p

Code: Select all

mysql nagiosql -pnagiosxi
update tbl_service set notification_interval=720;
update tbl_host set notification_interval=720;
quit
cd /usr/local/nagiosxi/scripts
./reconfigure_nagios.sh

Re: Mass change notification interval

Posted: Thu Jan 05, 2012 10:02 am
by jon.bilderback
Thank you. It looks like that did exactly what I needed.