[dev.icinga.com #10092] Error in Report for Icinga 2

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/10092

Created by lbetz on 2015-09-04 07:52:31 +00:00

Assignee: (none)
Status: New
Target Version: (none)
Last Update: 2015-09-04 07:52:31 +00:00 (in Redmine)

Icinga Version: 2.3.9
DB Type: MySQL
DB Version: 2.3.0
Jasper Version: 6.1.0

---

Because of changing the IDO behavior, i.e. the subreport services in Host shows the state of already deleted services. Must be added an 'and a.is_active = 1' to the query.

select a.name1,
b.display_name,
c.current_state,
c.check_command,
c.output
from icinga_objects a,
icinga_services b,
icinga_servicestatus c
where a.object_id = b.service_object_id

and a.is_active = 1
and b.service_object_id = c.service_object_id
and b.host_object_id = $P{p_host_object_id}