Getting Threshold value for a hostgroup services in one go

[progressive.nagiosXI]

Hi,

One of our client request to change CPU,MEMORY,DISK threshold on daily basis.And it is very difficult to track.

The Problem is sometime they want critical and warning threshold values set for their servers.

As in one hostgroup 400 windows servers,100 linux servers.

Please help us how to get threshold values for a hostgroup services in one go or any other easy way.

Thanks

[benjaminsmith]

Hello @progressive.nagiosXI,

Have you tried using the Configure > Tools > Bulk Modification Tool to edit the check command and arguments? You can select by hostgroup or service group.

[progressive.nagiosXI]

Hi smith,

we already use Bulk modification tool for large changes.but here we are not discuss about how to set values in bulk.

We want to know how to Getting Threshold Values for CPU,Memory,Disk in one go for a HostGroup.
(what Threshold we already set for a service).

Please find the attached sample report need to send every month for 600 Host.


Thanks

[benjaminsmith]

Hi,

Thanks for sharing the sample report, that's very helpful. The challenge here is that when Nagios stores the check command and arguments in the database, it's stored as a string (used by Core), and contains the thresholds along with other parameters depending on the check command.

There are a couple of options:

1. Use the configuration report from the Nagios Core Interface. Log into http://<server ip>/nagios and go to System > Configuration > Services. You can cut and paste this report to a spreadsheet and then sort by host, description and review the settings.

2. Write an sql query to pull the check command arguments from the nagios database. You'll find the check check command arguments in nagios_services table of the nagios database.

[progressive.nagiosXI]

Thanks benjamin

But this is difficult to get 14000 services in one browser page (browser hang),
Please provide some sql query which we run for hostgroupwise and print output to some file for further filteration.

Thanks

[ssax]

We're done for the day but I'll pick this up in the morning and send you a query, if you don't see it by midday tomorrow, reply to the post so that it pops up on our dashboard.

Thank you

[ssax]

We're going to need to do this a different way, the query is way too complex and I'm unable to get that information.

Please PM me a copy of your profile so that I can look at the services and see how they are setup so that I can make sure they are parsed properly.

[progressive.nagiosXI]

Hi

Profile shared in PM

Thanks

[ssax]

Received, thank you. I'm heading out for the day but I'll get this imported and get a SQL query for you that will get the information in the way you want it in the morning. If you don't hear from me by midday, please respond to this forum post so it pops up on my dashboard.

[progressive.nagiosXI]

Hi

Received, thank you. I'm heading out for the day but I'll get this imported and get a SQL query for you that will get the information in the way you want it in the morning. If you don't hear from me by midday, please respond to this forum post so it pops up on my dashboard.

Thanks