1771 Commits

Author SHA1 Message Date
Johannes Meyer
39f692e240 ServicedowntimeQuery: Improve JOIN performance
refs #9009
2015-06-16 08:11:45 +02:00
Johannes Meyer
bf7e6b3591 ServicecommentQuery: Improve JOIN performance
refs #9009
2015-06-16 08:11:38 +02:00
Johannes Meyer
104c8e7a2b ServicecommenthistoryQuery: Improve JOIN performance
refs #9009
2015-06-16 08:11:29 +02:00
Johannes Meyer
a6d1115d0f NotificationhistoryQuery: Improve JOIN performance
refs #9009
2015-06-16 08:11:18 +02:00
Johannes Meyer
4c3592a82e HoststatusQuery: Improve JOIN performance
refs #9009
2015-06-16 08:11:09 +02:00
Johannes Meyer
b774b2565f HoststatehistoryQuery: Improve JOIN performance
refs #9009
2015-06-16 08:11:03 +02:00
Johannes Meyer
326013428e HostnotificationQuery: Improve JOIN performance
refs #9009
2015-06-16 08:10:55 +02:00
Johannes Meyer
55a6b79ee5 HostgroupQuery: Improve JOIN performance
refs #9009
2015-06-16 08:10:49 +02:00
Johannes Meyer
0a98cb0255 HostdowntimestarthistoryQuery: Improve JOIN performance
refs #9009
2015-06-16 08:10:42 +02:00
Johannes Meyer
e73409eb6d HostdowntimeQuery: Improve JOIN performance
refs #9009
2015-06-16 08:10:32 +02:00
Johannes Meyer
41f1d3307b HostcommentQuery: Improve JOIN performance
refs #9009
2015-06-16 08:10:24 +02:00
Johannes Meyer
1a32d289b8 HostcommenthistoryQuery: Improve JOIN performance
refs #9009
2015-06-16 08:10:16 +02:00
Johannes Meyer
988bc2cf44 ServicestatusQuery: Improve JOIN performance
refs #9009
2015-06-16 08:09:54 +02:00
Matthias Jentsch
42de13a2b9 Merge branch 'feature/ssh-remote-connection-resource-configuration-7595'
resolves #7595
2015-06-15 17:30:42 +02:00
Johannes Meyer
7cbcb91fd7 DataView\Eventhistory: Allow to filter for custom variables
refs #9009
2015-06-15 16:53:22 +02:00
Johannes Meyer
9876a53f8e DataView\Eventgrid: Allow to filter for custom variables
refs #9009
2015-06-15 16:53:13 +02:00
Johannes Meyer
c6cf51b44c NotificationQuery: Force that the host and service subqueries are instantiated
Quick and dirty. I do not have enough time for a more proper version...

refs #9009
2015-06-15 16:24:57 +02:00
Johannes Meyer
a32f505fdd ObjectList: Fix that setFilter() violates interface Filterable
refs #9009
2015-06-15 16:08:04 +02:00
Johannes Meyer
a1e4e6e92b ObjectList: Implement interface Filterable
Allows to use instances of it for Controller::applyRestriction().

refs #9009
2015-06-15 16:05:37 +02:00
Johannes Meyer
09d9d00844 ContactgroupQuery: Do not use Zend_Select::group() but self::group()
Avoids duplicate GROUP BY expressions.
2015-06-15 15:10:58 +02:00
Johannes Meyer
548aec4233 DataView\Contactgroup: Add support for object restrictions
refs #9009
2015-06-15 15:08:04 +02:00
Johannes Meyer
b8efe314a0 DbQuery: Ignore wildcard only filters
This increases query performance vastly, since LIKE '%' comparisons
prevent the dbms from utilizing an index.
2015-06-15 13:59:46 +02:00
Johannes Meyer
07ebf11a07 DataView\Contact: Add support for object restrictions
refs #9009
2015-06-15 13:47:48 +02:00
Johannes Meyer
470c4a54a3 Eventgrid: Add support for object restrictions
refs #9009
2015-06-12 16:27:13 +02:00
Johannes Meyer
b6a7b43dd0 MonitoringBackend: Enforce that views and queries are of a particular naming scheme
I'm adding this mainly to not to break support with modules which are
utilizing our queries.
2015-06-12 14:46:46 +02:00
Johannes Meyer
4996f569fe monitoring: Ensure that views and queries are all named using the same scheme
That's "SomesuperQuery" and not "SomeSuperQuery", according to most
of the existing queries.
2015-06-12 14:42:49 +02:00
Johannes Meyer
528df1b26a EventHistory: Add support for object restrictions
refs #9009
2015-06-12 12:52:07 +02:00
Johannes Meyer
c35be4023b DowntimeendhistoryQuery: Use subqueries to fetch host and service downtimes
refs #9009
2015-06-12 12:45:59 +02:00
Johannes Meyer
dadb3853d7 DowntimestarthistoryQuery: Use subqueries to fetch host and service downtimes
refs #9009
2015-06-12 12:45:49 +02:00
Johannes Meyer
95b5bba65c Introduce query ServicedowntimeendhistoryQuery
refs #9009
2015-06-12 12:45:02 +02:00
Johannes Meyer
3ed858269c Introduce query ServicedowntimestarthistoryQuery
refs #9009
2015-06-12 12:44:49 +02:00
Johannes Meyer
7afa4dac9a Introduce query HostdowntimeendhistoryQuery
refs #9009
2015-06-12 12:44:35 +02:00
Johannes Meyer
18d3fcbbf7 Introduce query HostdowntimestarthistoryQuery
refs #9009
2015-06-12 12:44:25 +02:00
Johannes Meyer
51434c7255 CommentdeletionhistoryQuery: Use subqueries to fetch removed host and service comments
refs #9009
2015-06-11 16:16:17 +02:00
Johannes Meyer
b7a26c599d Introduce query ServicecommentdeletionhistoryQuery
refs #9009
2015-06-11 16:15:50 +02:00
Johannes Meyer
7ea9051d43 Introduce query HostcommentdeletionQuery
refs #9009
2015-06-11 16:15:29 +02:00
Johannes Meyer
7358eefed8 CommenthistoryQuery: Use subqueries to fetch host and service comments
refs #9009
2015-06-11 15:29:36 +02:00
Johannes Meyer
bf85fd62b5 Introduce query ServicecommenthistoryQuery
refs #9009
2015-06-11 15:28:57 +02:00
Johannes Meyer
26e895aedb Introduce query HostcommenthistoryQuery
refs #9009
2015-06-11 15:28:38 +02:00
Johannes Meyer
f17e9162eb StatehistoryQuery: Use subqueries for host and service state records
refs #9009
2015-06-11 12:36:10 +02:00
Johannes Meyer
5083301dea Introduce query ServicestatehistoryQuery
refs #9009
2015-06-11 12:35:29 +02:00
Johannes Meyer
0ead8d4821 Introduce query HoststatehistoryQuery
refs #9009
2015-06-11 12:35:15 +02:00
Johannes Meyer
ed66c1f2e4 ServicenotificationQuery: Apply query optimization from NotificationhistoryQuery
refs #9009
2015-06-11 12:34:55 +02:00
Johannes Meyer
f9948f5513 HostnotificationQuery: Apply query optimization from NotificationhistoryQuery
refs #9009
2015-06-11 12:34:40 +02:00
Johannes Meyer
b235bb6982 NotificationQuery: Select placeholder values when joining hosts, again
I've missed that our notification list-view detects based on a attribute's
value of which type a returned row is...

refs #9009
2015-06-10 17:04:00 +02:00
Johannes Meyer
5ad93d138c ServicenotificationQuery: Fix grouping when *all* tables are being joined
refs #9009
2015-06-10 17:01:58 +02:00
Johannes Meyer
0ccb765954 HostnotificationQuery: Fix grouping when *all* tables are being joined
refs #9009
2015-06-10 17:01:46 +02:00
Johannes Meyer
51a3213fca NotificationQuery: Add support for history related queries
refs #9009
2015-06-10 13:10:28 +02:00
Johannes Meyer
41ee39d48f EventHistoryQuery: Do not fetch columns which only exist in one subquery
Uses the same technique as the NotificationhistoryQuery for the output.
2015-06-10 13:08:57 +02:00
Johannes Meyer
db816e4a5c ServicegroupsummaryQuery: Fix that the service severity is not being fetched 2015-06-09 12:48:15 +02:00