[dev.icinga.com #2193] Services Dropdown does not contain all Services: #625

Closed
icinga-migration opened this Issue Dec 13, 2011 · 6 comments

Comments

Projects
None yet
1 participant
Member

icinga-migration commented Dec 13, 2011

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

Created by armin on 2011-12-13 15:16:41 +00:00

Assignee: mhein
Status: Resolved (closed on 2012-02-14 15:56:49 +00:00)
Target Version: 1.6.2
Last Update: 2014-08-30 08:04:48 +00:00 (in Redmine)

Icinga Version: 1.0.0
Icinga Web Version: 1.0.0
IDO Version: 1.0.0
OS Version: ---
DB Type: UNKNOWN
DB 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)
...

Changesets

2012-02-14 15:55:08 +00:00 by mhein 0161988

* Changed ExtJS id property (fixes #2193)
Member

icinga-migration commented Jan 20, 2012

Updated by mhein on 2012-01-20 11:30:23 +00:00

  • Target Version set to 1.7
Member

icinga-migration commented Feb 10, 2012

Updated by mhein on 2012-02-10 09:23:15 +00:00

  • Target Version changed from 1.7 to 1.6.2
Member

icinga-migration commented Feb 13, 2012

Updated by mhein on 2012-02-13 13:53:12 +00:00

  • Assigned to set to mhein
Member

icinga-migration commented Feb 14, 2012

Updated by mhein on 2012-02-14 15:56:49 +00:00

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

Applied in changeset 0161988.

Member

icinga-migration commented Dec 17, 2012

Updated by mfriedrich on 2012-12-17 19:39:35 +00:00

  • Project changed from Web to 29
  • Category deleted Reporting
Member

icinga-migration commented Aug 30, 2014

Updated by mfriedrich on 2014-08-30 08:04:48 +00:00

  • Project changed from 29 to Web
  • Category set to Reporting
  • Icinga Version set to 1
  • Icinga Web Version set to 1
  • IDO Version set to 1
  • OS Version set to ---
  • DB Type set to UNKNOWN
  • DB Version set to ---
  • Browser Version set to ---

icinga-migration added this to the 1.6.2 milestone Jan 17, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment