Eric Lippmann
66d76e7ad9
monitoring: Add host_notes to the host status query
...
refs #9009
2015-06-05 15:30:49 +02:00
Eric Lippmann
8cbb83d630
Merge branch 'master' into feature/monitoring-restrictions-9009
2015-06-05 15:29:16 +02:00
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
