Global Notifications off

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
sharding
Posts: 140
Joined: Thu Nov 08, 2012 11:08 am

Global Notifications off

Post by sharding »

Is there a script that support has that I could run to turn off all the notifications for everything ?

I ask as we had a prior core install converted into XI and we don't use notifications currently but I am thinking of doing so. I would rather start from a clean state where I know for sure that all notifications are off then set the ones we want to implement.

we're on XI 2014 R2.7 have about 503 hosts and 734 services currently so way too many to do by hand, not sure what other information is relevant for this question.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Global Notifications off

Post by ssax »

Do you have the enterprise license? If so, you could do it with bulk modifications. If not, I could whip up a SQL query that would set all the hosts/services to enable_notifications = 0?
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Global Notifications off

Post by ssax »

*** Make sure to take good backup, VM snapshots, etc before doing this - just in case.

Code: Select all

echo "update tbl_host set notifications_enabled = 0;" | mysql -uroot -pnagiosxi nagiosql
echo "update tbl_service set notifications_enabled = 0;" | mysql -uroot -pnagiosxi nagiosql
cd /usr/local/nagiosxi/scripts && ./reconfigure_nagios.sh
Locked