Nagios Support Forum

Posted: **Mon Oct 07, 2019 2:46 pm**

I am looking for something simple. Nothing is broken. I just require an assist figuring out a select statement.

I am trying to grab a metric from the Nagios DB.

I would like to be able to get a host count total if I provide a Host Group name. (or hg alias).

All I am looking for is a number to be returned.

Please advise.

Thank you

Steve B

Posted: **Mon Oct 07, 2019 3:44 pm**

Here you go in the nagios DB, replace HOSTGROUP_NAME with yours

Code: Select all

SELECT count(*) from nagios_hostgroup_members,nagios_objects,nagios_hostgroups 
WHERE nagios_hostgroups.hostgroup_id=nagios_hostgroup_members.hostgroup_id 
AND nagios_hostgroups.hostgroup_object_id=nagios_objects.object_id 
AND name1='HOSTGROUP_NAME';

Posted: **Mon Oct 07, 2019 3:59 pm**

Thank you.

Management metrics request drives this question. Now I can automate the data for them.

Please close...

Steve B

Nagios Support Forum

non-critical - SQL query assistance requested

non-critical - SQL query assistance requested

Re: non-critical - SQL query assistance requested

Re: non-critical - SQL query assistance requested