change threshold on multiple servers

[rnjie]

i have over 200 servers currently monitoring right now on my nagios xi and their thresholds are set to 85 for warning and 95 for critical, i want it changed to 80 for warning and 90 for critical for all services, is there a way this can be done in bulk, i tried looking into the bulk modification tool and i didn't see any option for warning and critical thresh-holds.

[mbellerue]

There's no solid way to do this in the GUI. You could do a lot of the heavy lifting at the database, and then clean up the left over services that didn't get covered.

But before you do anything in the database, make sure you have a good backup.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Unfortunately, because of how the data has to be stored, there's no rubber stamp method that just works in the majority of environments. It's going to be a lot of tuning your queries to bring back the correct data, and then running an update. What I can tell you is that the database you want is nagios, the table is nagios_services, and some of the fields that will be helpful are service_id, display_name, and check_command_args.

[rnjie]

thank you for your reply, but its still not lear what am supposed to do in the database, can you pleas give examples

[mbellerue]

Unfortunately not. The database changes are highly technical, and they're not something that we can really walk clients through, because each client's data is different from the next client's data.

There is another route we could take. You could create a new command definition that has your warning and critical thresholds hard coded. And then you could use the bulk modification tool to change your hosts to using that new command.