...
Code Block | ||
---|---|---|
| ||
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 |
---|
Since Because 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. |
...