Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[dev.icinga.com #9009] Apply host and service restrictions to related views as well #1586

Closed
icinga-migration opened this issue Apr 8, 2015 · 24 comments
Closed

[dev.icinga.com #9009] Apply host and service restrictions to related views as well #1586

icinga-migration opened this issue Apr 8, 2015 · 24 comments
Labels
area/monitoring Affects the monitoring module enhancement New feature or improvement
Milestone
2.0.0-rc1

Comments

@icinga-migration
Copy link

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

Created by jmeyer on 2015-04-08 09:53:20 +00:00

Assignee: jmeyer
Status: Resolved (closed on 2015-06-18 12:59:20 +00:00)
Target Version: 2.0.0-rc1
Last Update: 2015-06-18 12:59:20 +00:00 (in Redmine)

Changesets

2015-05-26 15:00:24 +00:00 by elippmann e9dd692

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 15:00:34 +00:00 by elippmann c81d13d

monitoring: Use the HostatusQuery in the HostStatus data view

refs #7344
refs #9009

2015-05-26 15:00:39 +00:00 by elippmann e240f7b

monitoring: Don't select host last ack, comment and downtime

Where unsure whether or not we will still support this.

refs #7344
refs #9009

2015-05-26 15:00:48 +00:00 by elippmann b24e339

monitoring: Prohibit sorting the HostStatus data view by service columns

refs #7344
refs #9009

2015-05-26 15:00:56 +00:00 by elippmann b0576d9

monitoring: Support selecting NULL as column

refs #9009

2015-05-26 15:02:13 +00:00 by elippmann 18499a4

monitoring: Support joining downtimes on the Hoststatus query

refs #7344
refs #9009

2015-05-26 15:02:41 +00:00 by elippmann 788481e

monitoring: Add Servicestatus query

refs #7344
refs #9009

2015-05-26 15:05:47 +00:00 by elippmann bb9b9bc

monitoring: Apply host and service restrictions to downtimes

refs #9009
refs #9319

2015-05-26 15:07:58 +00:00 by elippmann cd1ee3e

monitoring: Fix select columns for downtimes

refs #9009
refs #9319

2015-05-26 15:10:23 +00:00 by elippmann 6156554

monitoring: Fix downtime filter columns

refs #9009
refs #9319

2015-05-26 15:15:03 +00:00 by elippmann 0c1df33

monitoring: Fix select columns for downtimes, again

refs #9009
refs #9319

2015-05-29 09:23:47 +00:00 by elippmann 41be32a

monitoring: Provide only the monitoring/filter/objects restriction

We'll combine the hosts and services filter restrictions into a single restriction.

refs #9009

2015-05-29 09:40:26 +00:00 by elippmann 7793b61

monitoring: Combine restrictions w/ OR

If a user has more than one filter for the same restriction, the filters will be combined w/ or. The combined filters will then be applied w/ AND to the query.

refs #9009

2015-05-29 09:41:39 +00:00 by elippmann 4544653

monitoring: Don't apply restrictions in the downtime query

Restrictions should be applied from the controller.

refs #9009

2015-05-29 09:42:05 +00:00 by elippmann c17334d

monitoring: Support restricting the downtimes overview

refs #9009

2015-05-29 09:43:41 +00:00 by elippmann b1446fc

monitoring: Allow the hoststatus query to be filtered by restrictable columns

refs #9009

2015-05-29 09:44:34 +00:00 by elippmann 3a69e81

monitoring: Add restrictable filter columns to the downtime data view

refs #9009

2015-05-29 11:10:20 +00:00 by elippmann 3e53426

monitoring: Add query for host downtimes

refs #9009

2015-05-29 11:11:32 +00:00 by elippmann 22a83b7

monitoring: Add data view for host downtimes

refs #9009

2015-05-29 11:11:48 +00:00 by elippmann 02cabf3

monitoring: Add query for service downtimes

refs #9009

2015-05-29 11:12:03 +00:00 by elippmann b833a04

monitoring: Add data view for service downtimes

refs #9009

2015-05-29 11:12:34 +00:00 by elippmann 6e94755

monitoring: Use host and service downtime query in the downtime query

refs #9009

2015-05-29 11:13:28 +00:00 by elippmann ba07077

monitoring: Don't join downtimes in the hoststatus query

refs #9009

2015-05-29 11:20:01 +00:00 by elippmann e71682f

monitoring: Don't join downtimes in the servicestatus query

refs #9009

2015-05-29 13:09:21 +00:00 by elippmann 2cbadbf

Revert "monitoring: Don't select host last ack, comment and downtime"

This reverts commit e240f7b9550c9ed72b0d9840a140cc57180a8451.

refs #7344
refs #9009

2015-05-29 13:10:00 +00:00 by elippmann f1bb064

monitoring: Use the Servicedowntime data view in the ServiceList

refs #9009

2015-05-29 13:10:14 +00:00 by elippmann bb97269

monitoring: Use the Hostdowntime data view in the HostList

refs #9009

2015-05-29 13:34:18 +00:00 by elippmann ebe8a40

monitoring: Add host comment query

refs #9009

2015-05-29 13:34:38 +00:00 by elippmann a9680bf

monitoring: Add host comment data view

refs #9009

2015-05-29 13:34:52 +00:00 by elippmann 3c15b2b

monitoring: Add service comment query

refs #9009

2015-05-29 13:35:08 +00:00 by elippmann 82644b6

monitoring: Add service comment data view

refs #9009

2015-05-29 13:35:39 +00:00 by elippmann 85c21b0

monitoring: Use the host and service comment queries in the comment query

refs #9009

2015-05-29 13:36:03 +00:00 by elippmann 16ab26c

monitoring: Remove unused alias from the downtime query

refs #9009

2015-05-29 13:36:42 +00:00 by elippmann 41bc4e3

monitoring: Provide downtime_author only as filter column

refs #9009

2015-05-29 13:37:05 +00:00 by elippmann 54eb0ea

monitoring: Add restrictable filter columns to the comment data view

refs #9009

2015-05-29 13:38:03 +00:00 by elippmann 46fdaf4

monitoring: Fix select columns for the comment data views

refs #9009

2015-05-29 13:39:41 +00:00 by elippmann 42d9f05

monitoring: Apply host and service restrctions to the comments overview

refs #9009

2015-06-03 09:40:03 +00:00 by elippmann 798f4ad

monitoring: Add query for the host group summary

refs #9009

2015-06-03 09:40:55 +00:00 by elippmann 4b2c83f

monitoring: Use the host group summary query

refs #9009

2015-06-03 09:41:31 +00:00 by elippmann 947b543

monitoring: Fix host group summary select columns

refs #9009

2015-06-03 09:48:14 +00:00 by elippmann 761de2e

monitoring: Fix a join condition in the host status query

refs #9009

2015-06-03 09:48:34 +00:00 by elippmann 71f19b2

monitoring: Add missing columns to the service status query

refs #9009

2015-06-03 09:49:21 +00:00 by elippmann 6926452

monitoring: Add restrictable filter columns to the host group summary

refs #9009

2015-06-03 09:49:31 +00:00 by elippmann c1c8c1c

monitoring: Restrict the host group summary

refs #9009

2015-06-03 10:21:29 +00:00 by elippmann 8bc9e46

monitoring: Don't select host counts in the service group overview

We're not showing the counts.

refs #9009

2015-06-03 10:26:01 +00:00 by elippmann 082f9b1

monitoring: Don't provide unnecessary columns in the host group summary query

refs #9009

2015-06-03 10:48:04 +00:00 by elippmann d1bb19d

monitoring: Add service status summary query

refs #9009

2015-06-03 10:48:22 +00:00 by elippmann a8b925e

monitoring: Use the service status summary query in the service groups overview

refs #9009

2015-06-03 10:53:56 +00:00 by elippmann 6588c73

monitoring: Add restrictable filter columns to the service group summary

refs #9009

2015-06-03 10:54:25 +00:00 by elippmann fe488c7

monitoring: Restrict the service group overview

refs #9009

2015-06-03 10:54:51 +00:00 by elippmann 8e88864

monitoring: Fix host columns of the service status query

refs #9009

2015-06-03 12:13:15 +00:00 by elippmann ae78613

lib: Add sub query mode to the DbQuery

refs #9009

2015-06-03 12:14:55 +00:00 by elippmann 131af8e

monitoring: Add host status summary query

refs #9009

2015-06-03 12:15:09 +00:00 by elippmann e9308e8

monitoring: Add host status summary data view

refs #9009

2015-06-03 12:16:22 +00:00 by elippmann 8f11140

monitoring: Restrict the host overview and the host status summary

refs #9009

2015-06-03 12:39:10 +00:00 by elippmann f2f3fe2

monitoring: Add missing restrictable filter columns to the host status data view

refs #9009

2015-06-03 12:39:43 +00:00 by elippmann fc2a50a

monitoring: Add missing restrictable filter columns to the host status summary data view

refs #9009

2015-06-03 12:44:16 +00:00 by elippmann 7ffa1b9

monitoring: Add service status summary data view

refs #9009

2015-06-03 12:44:36 +00:00 by elippmann f479ea1

monitoring: Restrict the service status summary

refs #9009

2015-06-03 12:59:20 +00:00 by elippmann f8b4986

monitoring: Restrict the services overview

refs #9009

2015-06-05 07:11:10 +00:00 by elippmann b409609

monitoring: Use sub query count when joining service related tables to the host query

Fixes count problems.

refs #9009

2015-06-05 07:13:17 +00:00 by elippmann 28b1cf5

monitoring: Support joining the service status query by service groups

refs #9009

2015-06-05 07:14:26 +00:00 by elippmann c299fb3

monitoring: Support filtering the host group overview by service custom variables

refs #9009

2015-06-05 07:15:09 +00:00 by elippmann 1ea7335

monitoring: Support filtering the service group summary by service custom variables

refs #9009

2015-06-05 07:16:28 +00:00 by elippmann 82b0354

monitoring: Support filtering the service group overview by custom variables

refs #9009

2015-06-05 08:16:17 +00:00 by elippmann 7b17626

monitoring: Add query for service group summaries

refs #9009

2015-06-05 08:16:41 +00:00 by elippmann 480becd

monitoring: Fix pagination of the host group overview

refs #9009

2015-06-05 08:17:07 +00:00 by elippmann 3f02197

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 08:17:54 +00:00 by elippmann 76e2d8f

monitoring: Add service_last_state_change to the service status query

refs #9009

2015-06-05 08:28:50 +00:00 by elippmann e0b1179

monitoring: Use a sub select in the service status summary

refs #9009

2015-06-05 08:29:30 +00:00 by elippmann 0719c29

monitoring: Use the service group summary query

refs #9009

2015-06-05 09:46:45 +00:00 by elippmann 0440277

monitoring: Use grouping instead of distinct in the host comment query

refs #9009

2015-06-05 09:47:07 +00:00 by elippmann 2539e51

monitoring: Use grouping instead of distinct in the host downtime query

refs #9009

2015-06-05 09:47:39 +00:00 by elippmann c3c1993

monitoring: Use grouping instead of distinct in the service comment query

refs #9009

2015-06-05 09:48:03 +00:00 by elippmann c993ee6

monitoring: Use grouping instead of distinct in the service downtime query

refs #9009

2015-06-05 09:48:33 +00:00 by elippmann c08a98f

monitoring: Use grouping instead of distinct in the host status query

refs #9009

2015-06-05 09:49:00 +00:00 by elippmann 55921b4

monitoring: Fix service status query regarding handled/unhandled and using distinct

refs #9009

2015-06-05 10:36:56 +00:00 by elippmann 99b5c7b

monitoring: Add columns the to service status query required by the tactical overview

refs #9009

2015-06-05 10:37:29 +00:00 by elippmann b69b472

monitoring: Add columns the to host status query required by the tactical overview

refs #9009

2015-06-05 10:42:27 +00:00 by elippmann 2b3acc9

monitoring: Use host and service status queries in the status summary query

refs #9009

2015-06-05 10:42:55 +00:00 by elippmann 45d883d

monitoring: Add restrictable filter columns to the status summary

refs #9009

2015-06-05 10:43:24 +00:00 by elippmann b7afec8

monitoring: Restrict the tactical overview

refs #9009

2015-06-05 12:14:22 +00:00 by elippmann f3b84b7

monitoring: Restrict service summary when viewing a host or service

refs #9009

2015-06-05 12:40:17 +00:00 by elippmann 52a0ad3

monitoring: Remove unnecessary group call in the host comment query

refs #9009

2015-06-05 12:41:25 +00:00 by elippmann c735ee7

monitoring: Remove unnecessary group call in the host downtime query

refs #9009

2015-06-05 12:42:11 +00:00 by elippmann bbcd6e3

monitoring: Support restricting host groups of a host

refs #9009

2015-06-05 12:42:49 +00:00 by elippmann 80c8043

monitoring: Support restricting service groups of a service

refs #9009

2015-06-05 12:43:38 +00:00 by elippmann d830480

monitoring: Add missing restrictable columns to host and service comments and downtimes

refs #9009

2015-06-05 12:44:03 +00:00 by elippmann 5745790

monitoring: Use new restriction when viewing a host

refs #9009

2015-06-05 12:44:35 +00:00 by elippmann 5bc611f

monitoring: Use new restriction when viewing a service

refs #9009

2015-06-05 12:47:01 +00:00 by elippmann dae35b9

monitoring: Restrict host and service groups when viewing a host or service

refs #9009

2015-06-05 13:00:14 +00:00 by elippmann 2e059a9

monitoring: Use soft states in the host group summary again

refs #9009

2015-06-05 13:01:08 +00:00 by elippmann 4dc2eb9

monitoring: Use soft states in the host status summary query again

refs #9009

2015-06-05 13:01:45 +00:00 by elippmann 3425b71

monitoring: Restrict problem badges

The code should be placed somewhere else in the future.

refs #9009

2015-06-05 13:06:34 +00:00 by elippmann 1d77584

monitoring: Restrict the service grid

refs #9009

2015-06-05 13:30:49 +00:00 by elippmann 66d76e7

monitoring: Add host_notes to the host status query

refs #9009

2015-06-05 13:48:05 +00:00 by elippmann 6597e7a

monitoring: Add missing restrictable filter columns to the comment data view

refs #9009

2015-06-05 13:48:37 +00:00 by elippmann bb711f4

monitoring: Fix restrictable filter columns of the downtime view

refs #9009

2015-06-05 13:48:58 +00:00 by elippmann d4b0841

monitoring: Add missing filter column to the host group summary view

refs #9009

2015-06-05 13:49:26 +00:00 by elippmann 382007a

monitoring: Add missing filter columns to the service status data view

refs #9009

2015-06-05 13:49:48 +00:00 by elippmann d4a884b

monitoring: Fix filter columns of the service group summary

refs #9009

2015-06-05 13:50:11 +00:00 by elippmann 6c07a48

monitoring: Fix controller function fetchHostStats()

refs #9009

2015-06-08 15:07:34 +00:00 by jmeyer c0ffe4d

Introduce class HostnotificationQuery

refs #9009

2015-06-08 15:07:55 +00:00 by jmeyer 70e3434

Introduce class ServicenotificationQuery

refs #9009

2015-06-08 15:09:24 +00:00 by jmeyer 9229e46

NotificationQuery: Use subqueries to fetch host- and service-notifications

refs #9009

2015-06-08 15:10:16 +00:00 by jmeyer 2669d0e

monitoring: Restrict the notification overview

refs #9009

2015-06-08 15:23:36 +00:00 by jmeyer 75c5aab

NotificationQuery: Do not use a placeholder if it's possible to select a real value

refs #9009

2015-06-08 16:00:54 +00:00 by jmeyer 83c21f0

DowntimeQuery: Fix grouping

There was only one downtime for each host or service being fetched.

refs #9009

2015-06-08 16:01:16 +00:00 by jmeyer a4ad4e2

CommentQuery: Fix grouping

There was only one comment for each host or service being fetched.

refs #9009

2015-06-10 11:10:28 +00:00 by jmeyer 51a3213

NotificationQuery: Add support for history related queries

refs #9009

2015-06-10 15:01:46 +00:00 by jmeyer 0ccb765

HostnotificationQuery: Fix grouping when *all* tables are being joined

refs #9009

2015-06-10 15:01:58 +00:00 by jmeyer 5ad93d1

ServicenotificationQuery: Fix grouping when *all* tables are being joined

refs #9009

2015-06-10 15:04:00 +00:00 by jmeyer b235bb6

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-11 10:34:40 +00:00 by jmeyer f9948f5

HostnotificationQuery: Apply query optimization from NotificationhistoryQuery

refs #9009

2015-06-11 10:34:55 +00:00 by jmeyer ed66c1f

ServicenotificationQuery: Apply query optimization from NotificationhistoryQuery

refs #9009

2015-06-11 10:35:15 +00:00 by jmeyer 0ead8d4

Introduce query HoststatehistoryQuery

refs #9009

2015-06-11 10:35:29 +00:00 by jmeyer 5083301

Introduce query ServicestatehistoryQuery

refs #9009

2015-06-11 10:36:10 +00:00 by jmeyer f17e916

StatehistoryQuery: Use subqueries for host and service state records

refs #9009

2015-06-11 13:28:38 +00:00 by jmeyer 26e895a

Introduce query HostcommenthistoryQuery

refs #9009

2015-06-11 13:28:57 +00:00 by jmeyer bf85fd6

Introduce query ServicecommenthistoryQuery

refs #9009

2015-06-11 13:29:36 +00:00 by jmeyer 7358eef

CommenthistoryQuery: Use subqueries to fetch host and service comments

refs #9009

2015-06-11 14:15:29 +00:00 by jmeyer 7ea9051

Introduce query HostcommentdeletionQuery

refs #9009

2015-06-11 14:15:50 +00:00 by jmeyer b7a26c5

Introduce query ServicecommentdeletionhistoryQuery

refs #9009

2015-06-11 14:16:17 +00:00 by jmeyer 51434c7

CommentdeletionhistoryQuery: Use subqueries to fetch removed host and service comments

refs #9009

2015-06-12 10:44:25 +00:00 by jmeyer 18d3fcb

Introduce query HostdowntimestarthistoryQuery

refs #9009

2015-06-12 10:44:35 +00:00 by jmeyer 7afa4da

Introduce query HostdowntimeendhistoryQuery

refs #9009

2015-06-12 10:44:49 +00:00 by jmeyer 3ed8582

Introduce query ServicedowntimestarthistoryQuery

refs #9009

2015-06-12 10:45:02 +00:00 by jmeyer 95b5bba

Introduce query ServicedowntimeendhistoryQuery

refs #9009

2015-06-12 10:45:49 +00:00 by jmeyer dadb385

DowntimestarthistoryQuery: Use subqueries to fetch host and service downtimes

refs #9009

2015-06-12 10:45:59 +00:00 by jmeyer c35be40

DowntimeendhistoryQuery: Use subqueries to fetch host and service downtimes

refs #9009

2015-06-12 10:52:07 +00:00 by jmeyer 528df1b

EventHistory: Add support for object restrictions

refs #9009

2015-06-12 12:58:20 +00:00 by jmeyer eb93886

ListController: Do not apply restrictions before the filter editor is being set up

Might cause the restrictions being shown to the user..

refs #9009

2015-06-12 14:27:13 +00:00 by jmeyer 470c4a5

Eventgrid: Add support for object restrictions

refs #9009

2015-06-12 14:27:34 +00:00 by jmeyer d5ade9a

ListController: Restrict the eventgridAction

refs #9009

2015-06-15 11:47:48 +00:00 by jmeyer 07ebf11

DataView\Contact: Add support for object restrictions

refs #9009

2015-06-15 11:48:13 +00:00 by jmeyer aabdfec

ListController: Restrict the contacts view

refs #9009

2015-06-15 13:08:04 +00:00 by jmeyer 548aec4

DataView\Contactgroup: Add support for object restrictions

refs #9009

2015-06-15 13:08:25 +00:00 by jmeyer 53e6d4c

ListController: Restrict the contactgroups view

refs #9009

2015-06-15 13:58:15 +00:00 by jmeyer b83abc4

CommentController: Restrict display of single comments

refs #9009

2015-06-15 13:58:54 +00:00 by jmeyer 8187135

CommentsController: Restrict display of comments

refs #9009

2015-06-15 13:59:50 +00:00 by jmeyer 9a6e3a7

DowntimeController: Restrict display of single comments

refs #9009

2015-06-15 14:00:19 +00:00 by jmeyer 8b74952

DowntimesController: Restrict display of downtimes

refs #9009

2015-06-15 14:03:46 +00:00 by jmeyer 32c5d5a

ShowController: Restrict the servicestatus summary

I doubt that this is necessary, since showing hosts and services by using
this controller is deprecated, but I've added it nonetheless..

refs #9009

2015-06-15 14:04:14 +00:00 by jmeyer efc52e3

ShowController: Restrict the display of single contacts

refs #9009

2015-06-15 14:04:43 +00:00 by jmeyer ede8cc5

TimelineController: Restrict the displayed entries

refs #9009

2015-06-15 14:05:37 +00:00 by jmeyer a1e4e6e

ObjectList: Implement interface Filterable

Allows to use instances of it for Controller::applyRestriction().

refs #9009

2015-06-15 14:05:56 +00:00 by jmeyer ce48f63

HostsController: Restrict the display of multiple hosts

refs #9009

2015-06-15 14:06:13 +00:00 by jmeyer bd41839

ServicesController: Restrict the display of multiple services

refs #9009

2015-06-15 14:08:04 +00:00 by jmeyer a32f505

ObjectList: Fix that setFilter() violates interface Filterable

refs #9009

2015-06-15 14:24:57 +00:00 by jmeyer c6cf51b

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 14:26:07 +00:00 by jmeyer 4db9629

AlertsummaryController: Apply object restrictions

refs #9009

2015-06-15 14:53:13 +00:00 by jmeyer 9876a53

DataView\Eventgrid: Allow to filter for custom variables

refs #9009

2015-06-15 14:53:22 +00:00 by jmeyer 7cbcb91

DataView\Eventhistory: Allow to filter for custom variables

refs #9009

2015-06-16 06:09:54 +00:00 by jmeyer 988bc2c

ServicestatusQuery: Improve JOIN performance

refs #9009

2015-06-16 06:10:16 +00:00 by jmeyer 1a32d28

HostcommenthistoryQuery: Improve JOIN performance

refs #9009

2015-06-16 06:10:24 +00:00 by jmeyer 41f1d33

HostcommentQuery: Improve JOIN performance

refs #9009

2015-06-16 06:10:32 +00:00 by jmeyer e73409e

HostdowntimeQuery: Improve JOIN performance

refs #9009

2015-06-16 06:10:42 +00:00 by jmeyer 0a98cb0

HostdowntimestarthistoryQuery: Improve JOIN performance

refs #9009

2015-06-16 06:10:49 +00:00 by jmeyer 55a6b79

HostgroupQuery: Improve JOIN performance

refs #9009

2015-06-16 06:10:55 +00:00 by jmeyer 3260134

HostnotificationQuery: Improve JOIN performance

refs #9009

2015-06-16 06:11:03 +00:00 by jmeyer b774b25

HoststatehistoryQuery: Improve JOIN performance

refs #9009

2015-06-16 06:11:09 +00:00 by jmeyer 4c3592a

HoststatusQuery: Improve JOIN performance

refs #9009

2015-06-16 06:11:18 +00:00 by jmeyer a6d1115

NotificationhistoryQuery: Improve JOIN performance

refs #9009

2015-06-16 06:11:29 +00:00 by jmeyer 104c8e7

ServicecommenthistoryQuery: Improve JOIN performance

refs #9009

2015-06-16 06:11:38 +00:00 by jmeyer bf7e6b3

ServicecommentQuery: Improve JOIN performance

refs #9009

2015-06-16 06:11:45 +00:00 by jmeyer 39f692e

ServicedowntimeQuery: Improve JOIN performance

refs #9009

2015-06-16 06:11:54 +00:00 by jmeyer c0552b0

ServicedowntimestarthistoryQuery: Improve JOIN performance

refs #9009

2015-06-16 06:12:00 +00:00 by jmeyer 8bf269c

ServicegroupQuery: Improve JOIN performance

refs #9009

2015-06-16 06:12:08 +00:00 by jmeyer 7d9b09f

ServicenotificationQuery: Improve JOIN performance

refs #9009

2015-06-16 06:12:16 +00:00 by jmeyer 10a65f1

ServicestatehistoryQuery: Improve JOIN performance

refs #9009

2015-06-16 07:39:37 +00:00 by jmeyer a705244

HostcommenthistoryQuery: Fix invalid joins

refs #9009

2015-06-16 07:39:47 +00:00 by jmeyer 9a020f0

HostcommentQuery: Fix invalid joins

refs #9009

2015-06-16 07:39:56 +00:00 by jmeyer ba9d453

HostdowntimeQuery: Fix invalid joins

refs #9009

2015-06-16 07:40:10 +00:00 by jmeyer fee6c2f

HostdowntimestarthistoryQuery: Fix invalid joins

refs #9009

2015-06-16 07:40:20 +00:00 by jmeyer 6745b0b

HostgroupQuery: Fix invalid joins

refs #9009

2015-06-16 07:40:30 +00:00 by jmeyer 379e80b

HostnotificationQuery: Fix invalid joins

refs #9009

2015-06-16 07:40:40 +00:00 by jmeyer 627e681

HoststatehistoryQuery: Fix invalid joins

refs #9009

2015-06-16 07:40:49 +00:00 by jmeyer 72e5c07

HoststatusQuery: Fix invalid joins

refs #9009

2015-06-16 07:40:59 +00:00 by jmeyer 13cb52b

ServicecommenthistoryQuery: Fix invalid joins

refs #9009

2015-06-16 07:41:11 +00:00 by jmeyer 1983c49

ServicecommentQuery: Fix invalid joins

refs #9009

2015-06-16 07:41:26 +00:00 by jmeyer 0cc6938

ServicedowntimeQuery: Fix invalid joins

refs #9009

2015-06-16 07:41:36 +00:00 by jmeyer 755da0c

ServicedowntimestarthistoryQuery: Fix invalid joins

refs #9009

2015-06-16 07:41:43 +00:00 by jmeyer 1dd21c2

ServicegroupQuery: Fix invalid joins

refs #9009

2015-06-16 07:41:52 +00:00 by jmeyer 7a5156b

ServicenotificationQuery: Fix invalid joins

refs #9009

2015-06-16 07:42:04 +00:00 by jmeyer c11bd6d

ServicestatehistoryQuery: Fix invalid joins

refs #9009

2015-06-16 07:42:13 +00:00 by jmeyer 73e9db3

ServicestatusQuery: Fix invalid joins

refs #9009

2015-06-16 07:42:24 +00:00 by jmeyer 05e0568

StatusQuery: Fix invalid joins

refs #9009

2015-06-16 09:39:15 +00:00 by jmeyer 3cf7e93

Remove file Reftest.php

Looks like an accident.

refs #9009

2015-06-16 11:29:21 +00:00 by jmeyer 42a1d8e

HostnotificationQuery: Ensure that notifications not sent to a contact are fetched

refs #9009

2015-06-16 11:29:31 +00:00 by jmeyer bf70ec2

ServicenotificationQuery: Ensure that notifications not sent to a contact are fetched

refs #9009

2015-06-16 11:32:35 +00:00 by jmeyer d5f7ee3

Behave nicely when showing notifications not sent out to any contact

I noticed that there is no output shown for the history views in case no
contact has been notified, but time is short atm...

refs #9009
refs #9430

2015-06-16 15:16:59 +00:00 by jmeyer d0a7c48

MonitoredObjectController: Restrict the historyAction

refs #9009

2015-06-16 15:44:29 +00:00 by jmeyer 670d6e9

MonitoredObject: Ensure that the filter is applied to all queries

refs #9009

2015-06-16 16:13:04 +00:00 by jmeyer 95cb6de

Transfer changes from show/history.phtml to service/history.phtml

Was not recognised by git as host/history.phtml is the counterpart
for show/history.phtml in the tree.

refs #9009

2015-06-17 07:05:32 +00:00 by jmeyer 486fbd5

HoststatusQuery: Respect IDO schema version

refs #9009
fixes #9425

2015-06-17 08:00:29 +00:00 by jmeyer 5c1cdbc

IdoQuery: Join hosts and services automatically if required for customvars

refs #9009
fixes #9426

2015-06-17 08:11:59 +00:00 by jmeyer 4d72832

MonitoredObject: Don't apply restrictions to comments and downtimes

They're already filtered by object_type and the object's name.

refs #9009

2015-06-18 07:29:58 +00:00 by jmeyer 386447b

DbQuery: Add getter for GROUP BY clauses

Allows to override this in a child to provide group by clauses not
until they are actually required.

refs #9009

2015-06-18 07:39:23 +00:00 by jmeyer 9cfca36

ContactQuery: PostgreSQL grouping..

refs #9009

2015-06-18 08:09:50 +00:00 by jmeyer 535b740

ContactgroupQuery: PostgreSQL grouping...

refs #9009

2015-06-18 08:37:54 +00:00 by jmeyer 72de85a

HostdowntimeQuery: PostgreSQL grouping...

refs #9009

2015-06-18 08:38:15 +00:00 by jmeyer 068c0b6

ServicedowntimeQuery: PostgreSQL grouping...

refs #9009

2015-06-18 08:58:59 +00:00 by jmeyer 8ec494c

HostnotificationQuery: PostgreSQL grouping...

refs #9009

2015-06-18 08:59:52 +00:00 by jmeyer 4f42da4

ServicenotificationQuery: PostgreSQL grouping...

refs #9009

2015-06-18 09:17:14 +00:00 by jmeyer 99b0d63

HostcommentQuery: PostgreSQL grouping...

refs #9009

2015-06-18 09:17:36 +00:00 by jmeyer d66b7e8

ServicecommentQuery: PostgreSQL grouping...

refs #9009

2015-06-18 09:29:26 +00:00 by jmeyer b128bef

HostgroupQuery: PostgreSQL grouping...

refs #9009

2015-06-18 09:33:09 +00:00 by jmeyer b9479e7

ServicegroupQuery: PostgreSQL grouping...

refs #9009

2015-06-18 09:52:58 +00:00 by jmeyer 37103cf

HoststatusQuery: PostgreSQL grouping...

refs #9009

2015-06-18 10:08:05 +00:00 by jmeyer e181c57

ServicestatusQuery: PostgreSQL grouping...

refs #9009

2015-06-18 10:34:30 +00:00 by jmeyer b24b650

HoststatusQuery: Group by host- and servicegroup pk's if required

refs #9009

2015-06-18 10:34:49 +00:00 by jmeyer 5ef56fc

ServicestatusQuery: Group by host- and servicegroup pk's if required

refs #9009

2015-06-18 10:35:21 +00:00 by jmeyer a43cae9

HostgroupsummaryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 10:35:41 +00:00 by jmeyer b25d8e2

ServicegroupsummaryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 11:18:21 +00:00 by jmeyer 5c19c05

HoststatehistoryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 11:18:40 +00:00 by jmeyer b56114c

ServicestatehistoryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 11:18:52 +00:00 by jmeyer f20193e

HostcommenthistoryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 11:19:01 +00:00 by jmeyer 11ed6d6

ServicecommenthistoryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 11:19:14 +00:00 by jmeyer dc66c24

HostdowntimestarthistoryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 11:19:25 +00:00 by jmeyer 77fe094

ServicedowntimestarthistoryQuery: PostgreSQL grouping...

refs #9009

2015-06-18 12:33:41 +00:00 by jmeyer f2425a9

Select -1 as `state' for history queries not providing a valid state

PostgreSQL does not seem to be able to union null values with
integers...

refs #9009

2015-06-18 12:34:30 +00:00 by jmeyer dd81de3

NotificationQuery: Do not fetch non-history related columns for history queries

refs #9009

2015-06-18 12:54:29 +00:00 by jmeyer c8b0fab

Merge branch 'feature/monitoring-restrictions-9009'

Wohooo!!1

fixes #8343
fixes #8927
fixes #8928
fixes #9008
fixes #9319
fixes #9384
resolves #9009

Subtasks:
@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-05-29 11:28:28 +00:00

Build !#701 triggered by commit e71682f passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-05-29 13:40:11 +00:00

Build !#702 triggered by the commits 46fdaf4, 54eb0ea, 41bc4e3, 16ab26c, 85c21b0, 82644b6, 3c15b2b, a9680bf, ebe8a40, bb97269, f1bb064, 2cbadbf, 0729973, a93ef04 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-05-29 13:42:24 +00:00

Build !#703 triggered by commit 42d9f05 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-03 13:02:37 +00:00

Build !#718 triggered by the commits f8b4986, f479ea1, 7ffa1b9, fc2a50a, f2f3fe2, 8f11140, e9308e8, 131af8e, ae78613, 8e88864, fe488c7, 6588c73, a8b925e, d1bb19d, 082f9b1, 8bc9e46, c1c8c1c, 6926452, 71f19b2, 761de2e, 947b543, 4b2c83f, 798f4ad passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 07:19:52 +00:00

Build !#722 triggered by the commits 82b0354, 1ea7335, c299fb3, 28b1cf5, b409609 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 08:30:34 +00:00

Build !#723 triggered by the commits 0719c29, e0b1179, 76e2d8f, 3f02197, 480becd, 7b17626 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 09:50:12 +00:00

Build !#725 triggered by the commits 55921b4, c08a98f, c993ee6, c3c1993, 2539e51, 0440277 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 10:45:14 +00:00

Build !#728 triggered by the commits b7afec8, 45d883d, 2b3acc9, b69b472, 99b5c7b passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 12:48:12 +00:00

Build !#730 triggered by the commits dae35b9, 5bc611f, 5745790, d830480, 80c8043, bbcd6e3, c735ee7, 52a0ad3, f3b84b7 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 13:07:44 +00:00

Build !#733 triggered by the commits 1d77584, 3425b71, 4dc2eb9, 2e059a9 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 13:33:20 +00:00

Build !#735 triggered by the commits 66d76e7, 8cbb83d, 3e29046, 11a0066, 5dd3950, 1a0d170, 916a265, dd7cbf4, e7a875d, ab129d0, 1988342, 1e8151b, ff01ee4, 8e35bb4, 5f898a3, a5c3782, 28a28a8, 06fb6ff, 267e71f, 7213379, 00c31ff, cd0c418, 5d50eab, ae30a62, 2da45d2, c01512d, 0ce2227, 2490d0a, 8875ce7, 9bd5d41, cf96e66, 3fffd90, a558f28, 46e2393, cf95994, 9b4f3c9, 34edf87, 4496826, fa1a5c6, 7b9983d, 6661d49, 4c6a2b4, 17e7f1e, 66fd7df, 49bb09d, 1901f0a, c7ce149, 80e4e41, e936c76, 1385295, 62fff94, beb5bd7, 4bd36bc, 89311f9, 601b720, 29cc92a, d1a5321, 7127d5e, d097f7f, ea959c2, 04835db, cb4d6f0, c8e8a39, cc77902, b82d7d7, 3959dc2, a88037f, bb285db, 60ce78c, c94e6a3, 9fcebb0, b123afe, 5e0ae64, 068bfc0, 9f155ea, 2c9af2f, ad6b401, 385042e, 70d98f3, a4a1a29, 1a51368, 8309ab3, c7261bd, a298197, 32b99be, eb5c48a, 3b601de, 2572842, 60e5608, 1c6ded9, a669491, 1950ddc, 37f58e5, fd931e4, d7bdc59, 08f8fe6, 119b2fd, 58d78f5, 5326ce6, 647dd9d, 5fdaa2c, 1bfbce9, 31400ea, 124173f, 8b07a0e, c2d7f05, a304645, bd5d6e9, 903b02a, 701fd81, e0fe644, 8dbb215, b3e0851, 646cffd, 6c44f6a, 344e17a, 2833f9e, e06225f, cba36ec, cbf37bf, 23b7ab0, e025f59, 49f89ee, ba8d7e0, ee5cc63, d8097d4, 5aa9738, e55d434, 8713f59, d157dec, 1517c72, 0c9bac0, b58cd47, fd2ecf3, e31c99b, 0e37aad, 01b790c, 88ba718, 2cbea55, 32c1a84, 170379b, 45fd1b7, adc2d33, 676d209, e0f0fbf, 02afa9f, a75c74e, 6e382bd, e33791b, a7135ba, 4ac7557, 237b50f, 899a00e, 86146b8, 75c5aa2, e2c250c, 2164fcf, a4f38f2, 20f0b46, ec556ed, 54354b1, f3124ff, 18e413d, 88f5bb8, e5819ef, 5c6d5f5, 705bb66, 030db8c, 4f0b4e5, 59ff422, 2657254, 0686bc1, fac2ebc, 4833ff1, 10b158a, 4d79731, ba31be9, 9278d70, 6369643, ed166d6, 94cd4b9, 2cec4a6, 9891dc4, 9fdcada, 4a48997, 66611d4, f86a05e, fecf7a5, 539b824, 9c6a889, 0dda19d, bd07f78, 605ae3d, 32d1569, 8ea3cd0, 7dff1ca, 71fa736, 0938576, a3d5cfc, fb07f0b, f305a33, cf989a0, a1276fd, 7b6ca08, 9af25ac, 0e0341f, 742dfca, be36809, 3f25cf5, d39c697, 7a6837d, 524c449, 130fea3, 9eaa231, 07a5473, 5db6fc9, 8927121, e9fee2d, 0a38757, f93c2de, 223ecab, 47dfcf5, 7d98206, d5d0c67, 104c1c6, 7d08dd2, aa466ae, a9f0fd0, 2e0a444, c91d3e5, 053c9cd, 399bbf0, 44bbd93, b3957c5, ca166b0, 3aaa6d3, 30bc1db, f1c82fc, 59ec11f, 6ef4bbe, 8690056, 2c1fac9, 84f20ec, 12ff708, 938da80, 5ace0a0, 1e1b954, f383ddd, f83d16a, eac5e39, 99be358, ba4330d, 4d83b2f, 16a7b01, 4044e56, 108f551, cfa9176, 7b2ed3b, f2ad283, d63381c, 9c799dc, b1cbc14, f1f1710, e228404, 8902930, 5cc7f26, de68d78, 37e47f0, 1682b0e, 58233b0, b1454c1, 7b2fc1b, 8cf0c29, bd136d3, d71df6a, 271e350, d171dd2, d0a353c, 3e8ef5c, f9089c3, 842b043, b86a002, 9163fb0, 100d475, 437090d, c441117, e74194c, 99ac0b7, 7b41fc0, 1824eb9, 68657c0, 870e75c, fa1906e, 3b93b84, 7b7a7c9, 6612e4c, 6640175, 5baa059, 9921343, 7178026, ecd059d, e7789ed, ca5ef2d, d09ea28, 3da144f, adae7b3, 7960e91, a2cd5d6, a1d8ed6, c9dcddb, 847c02e, 33628cb, b45e576, 97caeb2, 319ca36, 60a8654, 11f522d, a7af546, 6ca68f4, 39473e8, b51ce9c, 8058eb0 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 13:50:46 +00:00

Build !#738 triggered by the commits d4a884b, 382007a, d4b0841, bb711f4, 6597e7a passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-05 13:52:59 +00:00

Build !#739 triggered by commit 6c07a48 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Eric Lippmann

@icinga-migration
Copy link
Author

Updated by jmeyer on 2015-06-11 08:00:24 +00:00

  • Assigned to set to jmeyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-11 14:29:14 +00:00

Build !#748 triggered by the commits 51434c7, b7a26c5, 7ea9051, 7358eef, bf85fd6, 26e895a, f17e916, 5083301, 0ead8d4, ed66c1f, f9948f5, b235bb6, 5ad93d1, 0ccb765, 51a3213, 41ee39d, db816e4, d5dffe9, eba862a, f2c7d56, fb52ee5, 27d2af5, 17fa0d3, a4ad4e2, 83c21f0, 75c5aab, 2669d0e, 9229e46, 70e3434, c0ffe4d, 44e3dba, 91cee3a, 07041fa, 3600e10, ddba1d8, 1bd18c5, 54b960a, 0b1bb54, e15b144, 6a914dc, 2dd04bb, e66f873, 76e748c, c800f1e, 840069b, 8d84576, 3b8ab42, ce7e9f6, 34992c2, e910a5a, 797e9de, 24cb6bf, 05b7c3a, 975edbe, e6837cf, e9e97cb, 6dedb48, 5688f0c, 447088a, 7ebf185, 6b14195, 0a5dcd2, 67322e0, cacd97f, 02d2ea6, 0ab192c, 127489c, cbc7310, ee2462a, 602f0cf, 3fd0d99, 7577b37, 90d946f, d9eb8f9, 89d9922, e65cf95, 86c63ec, 757e993, 96f5f8f, e0c0e9c, 5b8de49, 887bd0b, 441fc33, 38cecdb, b842a39 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-14 04:06:44 +00:00

Build !#749 triggered by the commits d5ade9a, 470c4a5, eb93886, b6a7b43, 4996f56, 76b1746, 528df1b, c35be40, dadb385, 95b5bba, 3ed8582, 7afa4da, 18d3fcb passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-15 12:07:06 +00:00

Build !#750 triggered by the commits b8efe31, aabdfec, 07ebf11 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-15 14:28:45 +00:00

Build !#751 triggered by the commits 4db9629, 5545b4a, c6cf51b, a32f505, bd41839, ce48f63, a1e4e6e, ede8cc5, efc52e3, 32c5d5a, 8b74952, 9a6e3a7, 8187135, b83abc4, 1a08102, 09d9d00, 53e6d4c, 548aec4, 2fceac9 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-15 14:56:31 +00:00

Build !#752 triggered by the commits 7cbcb91, 9876a53 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-18 10:10:41 +00:00

Build !#763 triggered by the commits e181c57, 37103cf, b9479e7, b128bef, d66b7e8, 99b0d63, 4f42da4, 8ec494c, 068c0b6, 72de85a, 6e40b79, 535b740, 9cfca36, 1169793, 386447b passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-18 10:38:55 +00:00

Build !#764 triggered by the commits b25d8e2, a43cae9, 5ef56fc, b24b650 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-18 11:22:27 +00:00

Build !#766 triggered by the commits 77fe094, dc66c24, 11ed6d6, f20193e, b56114c, 5c19c05 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by icinga-kanban on 2015-06-18 12:37:35 +00:00

Build !#769 triggered by the commits dd81de3, f2425a9 passed successfully.

Branch: origin/feature/monitoring-restrictions-9009
Author: Johannes Meyer

@icinga-migration
Copy link
Author

Updated by jmeyer on 2015-06-18 12:59:20 +00:00

  • Status changed from New to Resolved

Applied in changeset c8b0fab.

@icinga-migration icinga-migration added enhancement New feature or improvement area/monitoring Affects the monitoring module labels Jan 17, 2017
@icinga-migration icinga-migration added this to the 2.0.0-rc1 milestone Jan 17, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/monitoring Affects the monitoring module enhancement New feature or improvement
Projects
None yet
Milestone
2.0.0-rc1
Development

No branches or pull requests
1 participant
@icinga-migration