Mass change notification interval

[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

[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

[jon.bilderback]

Thank you. It looks like that did exactly what I needed.