article Finding and updating hosts without a host check

Run the following query to generate a list of hosts (including their groups) without a defined host check:

SELECT e.name, eg.name from entity e, entity_group eg

WHERE e.entity_group_id = eg.entity_group_id AND e.entity_id IN

(select e.entity_id from entity e left join erdc_instance ei on e.entity_id = ei.entity_id and ei.is_host_check = 1 where ei.is_host_check is null)

Next, run the following query to generate a list of every service monitor attached to all the hosts that are currently without a host check:

SELECT e.entity_id, e.name, ei.erdc_instance_id, ei.name, ei.is_host_check

FROM entity e, erdc_configuration ec, erdc_instance ei

WHERE ei.configuration_id = ec.id and e.entity_id = ei.entity_id and e.entity_id IN

(select e.entity_id from entity e left join erdc_instance ei on e.entity_id = ei.entity_id and ei.is_host_check = 1 where ei.is_host_check is null)

Note that since the second query lists every service monitor for each of these hosts, you will see the entity_id and the entity_name every time a service monitor is listed.


To update the host check for each of these hosts, use the output from the queries above to determine which service monitor you want as the host check for each particular host and then run the following update statement for each host:

UPDATE erdc_instance ei, entity e set ei.is_host_check = 'true'

WHERE ei.erdc_instance_id = <the erdc_instance_id of the service monitor you want to set as the host check>

AND e.entity_id = <the entity_id of the host you want to set the host check for>

Related Articles


Why am I still receiving alerts when my host check is down?

RatingViews
article

When a host check goes into a failure state (WARN,CRIT) the other service monitors on the target element will have their alerts/actions supressed and enter an UNKN state until the host check...

By: uptime Support | Date Created: 8-27-2010 | Last Modified: 8-13-2011 | Index: 498

  1812

Changing the default host check

RatingViews
article

At times it may be required to change the default up.time host check from PING to UPTIME. Unfortunately there is no way to automatically make this update, up.time will always add the 2 default...

By: uptime Support | Date Created: 10-8-2009 | Last Modified: 8-13-2011 | Index: 396

  2255

Finding your HostID

RatingViews
article

By: uptime Support | Date Created: 9-27-2005 | Last Modified: 6-12-2012 | Index: 007

  7399

Process Check monitor does not check the full Solaris path

RatingViews
article

Problem: At times the Check for a Process (Process Check) monitor may not check against a processes full path on Solaris systems. The up.time agent uses the "ps" command to match running processes....

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 9-9-2011 | Index: 236

  4237

Finding your IBM HMC or VIO version

RatingViews
article

To find which Virtual IO Server version is in use run these commands on the VIO Server command line. $ ioslevel 1.3.0.0 $ oem_platform_level AIX Version: 5.3.0.0 To find out what HMC Server...

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 9-7-2011 | Index: 243

  27375

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement