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

[icinga-migration]

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)

[icinga-migration]

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

• Target Version set to 1.7

[icinga-migration]

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

• Target Version changed from 1.7 to 1.6.2

[icinga-migration]

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

• Assigned to set to mhein

[icinga-migration]

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.

[icinga-migration]

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

• Project changed from Web to 29
• Category deleted Reporting

[icinga-migration]

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