Eric Lippmann
4dc2eb9f4a
monitoring: Use soft states in the host status summary query again
...
refs #9009
2015-06-05 15:01:08 +02:00
Eric Lippmann
2e059a9bb7
monitoring: Use soft states in the host group summary again
...
refs #9009
2015-06-05 15:00:14 +02:00
Eric Lippmann
80c80436cf
monitoring: Support restricting service groups of a service
...
refs #9009
2015-06-05 14:42:49 +02:00
Eric Lippmann
bbcd6e3a2b
monitoring: Support restricting host groups of a host
...
refs #9009
2015-06-05 14:42:11 +02:00
Eric Lippmann
c735ee799c
monitoring: Remove unnecessary group call in the host downtime query
...
refs #9009
2015-06-05 14:41:25 +02:00
Eric Lippmann
52a0ad363f
monitoring: Remove unnecessary group call in the host comment query
...
refs #9009
2015-06-05 14:40:17 +02:00
Eric Lippmann
2b3acc99e2
monitoring: Use host and service status queries in the status summary query
...
refs #9009
2015-06-05 12:42:27 +02:00
Eric Lippmann
b69b47277e
monitoring: Add columns the to host status query required by the tactical overview
...
refs #9009
2015-06-05 12:37:29 +02:00
Eric Lippmann
99b5c7b243
monitoring: Add columns the to service status query required by the tactical overview
...
refs #9009
2015-06-05 12:36:56 +02:00
Eric Lippmann
55921b4854
monitoring: Fix service status query regarding handled/unhandled and using distinct
...
refs #9009
2015-06-05 11:49:00 +02:00
Eric Lippmann
c08a98f6ac
monitoring: Use grouping instead of distinct in the host status query
...
refs #9009
2015-06-05 11:48:33 +02:00
Eric Lippmann
c993ee63b7
monitoring: Use grouping instead of distinct in the service downtime query
...
refs #9009
2015-06-05 11:48:03 +02:00
Eric Lippmann
c3c1993870
monitoring: Use grouping instead of distinct in the service comment query
...
refs #9009
2015-06-05 11:47:39 +02:00
Eric Lippmann
2539e51549
monitoring: Use grouping instead of distinct in the host downtime query
...
refs #9009
2015-06-05 11:47:07 +02:00
Eric Lippmann
044027772d
monitoring: Use grouping instead of distinct in the host comment query
...
refs #9009
2015-06-05 11:46:45 +02:00
Eric Lippmann
e0b117915a
monitoring: Use a sub select in the service status summary
...
refs #9009
2015-06-05 10:28:50 +02:00
Eric Lippmann
76e2d8f5ee
monitoring: Add service_last_state_change to the service status query
...
refs #9009
2015-06-05 10:17:54 +02:00
Eric Lippmann
3f02197891
monitoring: Remove allowCustomVars form the host status summary query
...
allowCustomVars is not needed on this query because all filters are passed to the underlying query.
refs #9009
2015-06-05 10:17:07 +02:00
Eric Lippmann
480becd3d6
monitoring: Fix pagination of the host group overview
...
refs #9009
2015-06-05 10:16:41 +02:00
Eric Lippmann
7b176261f8
monitoring: Add query for service group summaries
...
refs #9009
2015-06-05 10:16:17 +02:00
Eric Lippmann
1ea7335b96
monitoring: Support filtering the service group summary by service custom variables
...
refs #9009
2015-06-05 09:15:09 +02:00
Eric Lippmann
28b1cf5762
monitoring: Support joining the service status query by service groups
...
refs #9009
2015-06-05 09:13:17 +02:00
Eric Lippmann
b409609df7
monitoring: Use sub query count when joining service related tables to the host query
...
Fixes count problems.
refs #9009
2015-06-05 09:11:10 +02:00
Eric Lippmann
131af8e818
monitoring: Add host status summary query
...
refs #9009
2015-06-03 14:14:55 +02:00
Eric Lippmann
8e88864f4a
monitoring: Fix host columns of the service status query
...
refs #9009
2015-06-03 12:54:51 +02:00
Eric Lippmann
d1bb19d037
monitoring: Add service status summary query
...
refs #9009
2015-06-03 12:48:04 +02:00
Eric Lippmann
082f9b1edd
monitoring: Don't provide unnecessary columns in the host group summary query
...
refs #9009
2015-06-03 12:26:01 +02:00
Eric Lippmann
71f19b2cc6
monitoring: Add missing columns to the service status query
...
refs #9009
2015-06-03 11:48:34 +02:00
Eric Lippmann
761de2eb33
monitoring: Fix a join condition in the host status query
...
refs #9009
2015-06-03 11:48:14 +02:00
Eric Lippmann
798f4adc34
monitoring: Add query for the host group summary
...
refs #9009
2015-06-03 11:40:03 +02:00
Johannes Meyer
cd0c418854
Merge branch 'master' into feature/user-and-group-management-8826
2015-06-02 10:44:13 +02:00
Eric Lippmann
16ab26cb7c
monitoring: Remove unused alias from the downtime query
...
refs #9009
2015-05-29 15:36:03 +02:00
Eric Lippmann
85c21b042d
monitoring: Use the host and service comment queries in the comment query
...
refs #9009
2015-05-29 15:35:39 +02:00
Eric Lippmann
3c15b2b972
monitoring: Add service comment query
...
refs #9009
2015-05-29 15:34:52 +02:00
Eric Lippmann
ebe8a409e3
monitoring: Add host comment query
...
refs #9009
2015-05-29 15:34:18 +02:00
Eric Lippmann
0729973045
monitoring: Add last *comment columns to the host status queries
2015-05-29 15:07:06 +02:00
Eric Lippmann
e71682ffb3
monitoring: Don't join downtimes in the servicestatus query
...
refs #9009
2015-05-29 13:20:01 +02:00
Eric Lippmann
ba07077ca8
monitoring: Don't join downtimes in the hoststatus query
...
refs #9009
2015-05-29 13:13:28 +02:00
Eric Lippmann
6e94755c4c
monitoring: Use host and service downtime query in the downtime query
...
refs #9009
2015-05-29 13:12:34 +02:00
Eric Lippmann
02cabf3a50
monitoring: Add query for service downtimes
...
refs #9009
2015-05-29 13:11:48 +02:00
Eric Lippmann
3e53426ece
monitoring: Add query for host downtimes
...
refs #9009
2015-05-29 13:10:20 +02:00
Eric Lippmann
b1446fcb23
monitoring: Allow the hoststatus query to be filtered by restrictable columns
...
refs #9009
2015-05-29 11:43:41 +02:00
Eric Lippmann
4544653c2e
monitoring: Don't apply restrictions in the downtime query
...
Restrictions should be applied from the controller.
refs #9009
2015-05-29 11:41:39 +02:00
Johannes Meyer
58d78f59f3
DbQuery: Initialize self::$select as early as possible
...
I'd like to use Zend's implementation instead of re-inventing the wheel just
because someone decided to only work with a copy of it in the frameworks
query but do exactly the opposite in the monitoring module's IDO query...
2015-05-28 13:49:36 +02:00
Eric Lippmann
bb9b9bc754
monitoring: Apply host and service restrictions to downtimes
...
refs #9009
refs #9319
2015-05-26 17:05:47 +02:00
Eric Lippmann
788481e2b1
monitoring: Add Servicestatus query
...
refs #7344
refs #9009
2015-05-26 17:02:41 +02:00
Eric Lippmann
18499a4a59
monitoring: Support joining downtimes on the Hoststatus query
...
refs #7344
refs #9009
2015-05-26 17:02:13 +02:00
Eric Lippmann
b0576d93de
monitoring: Support selecting NULL as column
...
refs #9009
2015-05-26 17:00:56 +02:00
Eric Lippmann
e9dd69267c
monitoring: Prepare HoststatusQuery to be used when viewing hosts
...
The Hoststatusquery does not include the joins for last ack, comment and downtime as where unsure whether or not we will still support this.
refs #7344
refs #9009
2015-05-26 17:00:24 +02:00
Matthias Jentsch
4ac7557c2f
Show host and service notes in the host and service detail view
...
refs #8235
2015-05-26 16:40:32 +02:00
