Bug #2193

Services Dropdown does not contain all Services:

Added by armin over 2 years ago. Updated over 1 year ago.

Status:ResolvedStart date:12/13/2011
Priority:NormalDue date:
Assignee:mhein% Done:

100%

Category:-
Target version:Icinga 1.x - 1.6.2
Icinga Version: DB Version:
Icinga Web Version: Jasper Version:
IDO Version: Browser Version:
DB Type:

Description

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)
...

Associated revisions

Revision 01619889
Added by mhein about 2 years ago

  • Changed ExtJS id property (fixes #2193)

History

#1 Updated by mhein over 2 years ago

  • Target version set to 1.7

#2 Updated by mhein about 2 years ago

  • Target version changed from 1.7 to 1.6.2

#3 Updated by mhein about 2 years ago

  • Assignee set to mhein

#4 Updated by mhein about 2 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Applied in changeset commit:01619889da2c3ede33be63a7201d51057eaf4a0f.

#5 Updated by dnsmichi over 1 year ago

  • Project changed from Web to Report Module
  • Category deleted (Reporting)

Also available in: Atom PDF