Services Dropdown does not contain all Services:
|Target version:||Icinga 1.x - 1.6.2|
|Icinga Version:||DB Version:|
|Icinga Web Version:||Jasper Version:|
|IDO Version:||Browser Version:|
The Service selection dropdown Lists under Reporting do not contain all Services. The SQL Statement which queries the services looks OK (mysql logfile):
SELECT DISTINCT i.object_id AS i__object_id, i.object_id AS i__object_id, i.name2 AS i__name2, i.name2 AS i__name2, i6.name1 AS i6__name1, i.object_id AS i__0, i6.name1 AS i6__1, i.name2 AS i__2, i.name2 AS i__3 FROM icinga_objects i INNER JOIN icinga_services i2 ON i.object_id = i2.service_object_id INNER JOIN icinga_hosts i3 ON i2.host_object_id = i3.host_object_id LEFT JOIN icinga_hoststatus i4 ON i3.host_object_id = i4.host_object_id LEFT JOIN icinga_servicestatus i5 ON i2.service_object_id = i5.service_object_id INNER JOIN icinga_objects i6 ON i3.host_object_id = i6.object_id WHERE (i2.config_type = '1' AND i.is_active = 1) ORDER BY i.name2 ASC
the Result looks like:
... | 515 | 515 | events | win_events | srv01 | 515 | srv01 | events | events | | 581 | 581 | events | win_events | srv02 | 581 | srv02 | events | events | | 637 | 637 | services | win_services | srv03 | 637 | srv03 | services | services | | 640 | 640 | services | win_services | srv04 | 640 | srv04 | services | services | ...
But in the dropdown box only the last Service of same type is displayed:
... srv02 - events srv04 - services ...
Same behavior in your online Demoversion, if you drop down Services under Reporting, ServiceActivityReportingInGivenTime you should see three mysql Services, but only one is displayed.
... c1-db1 - mysql (not displayed) c1-db2 - mysql (not displayed) c2-dbserver-1 - mysql (displayed) ...