819 Commits

Author SHA1 Message Date
Eric Lippmann
58e3ae46a7 Fix servicegroup subquery filter in the servicegroup view 2019-07-30 09:17:25 +02:00
Eric Lippmann
9a75e101ee Support subquery filters in filter chains
Before, combined membership filters were only possible in filter
expressions, e.g. hostgroup_name=(a&b). Now, also
(hostgroup_name=a&hostgroup_name=b) is supported which makes it easier
to build such filters with the filter editor.
2019-07-30 09:17:25 +02:00
Johannes Meyer
a33fda9dd7
Merge pull request #3846 from Icinga/feature/contact-and-contactgroup-filter
Add contact and contactgroup filters
2019-07-30 09:07:55 +02:00
Eric Lippmann
227cb2c512 Fix grouping error when selecting the notification id 2019-07-29 14:03:40 +02:00
Eric Lippmann
98388c4346 Link to the event detail from the notifications view 2019-07-29 14:03:40 +02:00
Johannes Meyer
f32dac7a70 ServicestatusQuery: Add latency to next_update calculation..
..and double the entire result

refs #3212
2019-07-29 09:12:46 +02:00
Johannes Meyer
44f63576d1 HoststatusQuery: Add latency to next_update calculation..
..and double the entire result

refs #3212
2019-07-29 09:12:46 +02:00
Eric Lippmann
bcc867d48e Allow to filter for contact groups 2019-07-29 09:12:01 +02:00
Eric Lippmann
54f9c68887 Show notifications before any other event in the history views 2019-07-23 14:48:00 +02:00
Eric Lippmann
f80a61d9e5 Respect notification type of subqueries 2019-07-23 14:48:00 +02:00
Eric Lippmann
1d1fd0b3b2 Use notification_reason for new notification types 2019-07-23 14:48:00 +02:00
Johannes Meyer
39fbd3e27e monitoring: Re-add missing query columns to event overview
`hostgroup`, `hostgroup_alias`, `servicegroup`, `servicegroup_alias`

fixes #3848
2019-07-18 14:50:35 +02:00
Eric Lippmann
523a35f4c1 Allow to filter for contacts 2019-07-08 18:00:28 +02:00
Johannes Meyer
5961f43aa9
Merge pull request #3781 from mdetrano/bugfix/cant_search_for_output_in_event_history_2266
Fixes 2266.  Special handling of notification 'output' field.
2019-05-27 08:29:34 +02:00
Marc DeTrano
5e5a5c68cc Fixes 2266. Special handling of notification 'output' field to avoid using aggregate function in WHERE clause of query...which dumps an error
style fixup, exact === usage
2019-05-24 17:04:02 -06:00
Johannes Meyer
a063cc9dcf
Merge pull request #3247 from mdetrano/feature/improve-eventgrid-performance-12732
Improve Event Grid performance
2019-05-24 07:53:21 +02:00
mdetrano
c05d15c427
Update modules/monitoring/library/Monitoring/Backend/Ido/Query/EventgridservicesQuery.php
extra line fixup, as suggested

Co-Authored-By: Jennifer Mourek <jennifer.mourek@netways.de>
2019-05-22 13:29:12 -06:00
Johannes Meyer
2e2a269549
Merge pull request #3712 from ConstantinMatheis/master
Add check source to history details view.
2019-04-18 14:37:26 +02:00
Johannes Meyer
a8832517bf Ido\Query: Add missing host and service columns to history queries
fixes #3721
2019-04-16 10:24:33 +02:00
Marc DeTrano
e7d117e1b6 Improve Eventgrid performance by limititing query time range, and only querying for hosts or services as requested in the form. 2019-04-02 10:15:33 -06:00
Constantin Matheis
76cd8a0321 Added Check source to Details view.
refs #3687
2019-03-07 10:33:51 +01:00
Eric Lippmann
8300011c6f Use requireVirtualTable() 2018-11-15 11:10:31 +01:00
Eric Lippmann
dda390b3d8 Require virtual table hosts
refs #3564
2018-11-14 10:22:17 +01:00
Johannes Meyer
dab9fea0d4
Merge pull request #3457 from Icinga/feature/proper-results-when-filtering-for-linked-objects-2934
Proper results when filtering for linked objects
2018-07-19 09:15:58 +02:00
Eric Lippmann
7624d99070 Use subquery filters for contacts if appropriate
refs #2934
2018-07-18 17:47:40 +02:00
Eric Lippmann
424f687f5d
Merge pull request #3532 from Icinga/bugfix/ido-check_interval
Fetch check_interval property of monitored objects, too
2018-07-18 16:32:37 +02:00
Eric Lippmann
c168ebfe3a Fix subquery joins for host and service group views
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
3a434320e2 Fix subquery joins for negative filters
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
b7f0270a24 Use SELECT 1 for subquery filters
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
28e68f8f8a Fix group base 2018-07-18 15:50:37 +02:00
Eric Lippmann
c3d25e1a59 Use subquery filters for service groups if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
61d325fa8a Use subquery filters for host groups if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
a3ec0df7c5 Use subquery filters for service flapping history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
c4de14eb05 Use subquery filters for host flapping history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
1d4ee7824a Use subquery filters for service comment history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
2ee0f99ed1 Use subquery filters for host comment history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
df7b5d663a Use subquery filters for service downtime history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
0ca97d191f Use subquery filters for host downtime history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
81b6b0129b Use subquery filters for service state history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
bdb73ec06e Use subquery filters for host state history if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
27f4fe82cd Use subquery filters for service notifications if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
84c6055a17 Use subquery filters for service comments if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
a84cc40aa8 Use subquery filters for host notifications if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
db50d40068 Use subquery filters for host comments if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
271a1d72f1 Use subquery filters for contact groups if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
f7f02bdc8f Use subquery filters for service downtimes if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Eric Lippmann
9f7b9edffe Use subquery filters for host downtimes if appropriate
refs #2934
2018-07-18 15:50:37 +02:00
Johannes Meyer
186ef5a5a7 Use subquery filters for services if appropriate
refs #2934

Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
2018-07-18 15:50:37 +02:00
Johannes Meyer
824fa870a2 Use subquery filters for hosts if appropriate
refs #2934

(EL): Alternative service group subquery filter:

```php
$this->joinVirtualTable('services');
$query->joinVirtualTable('members');
return ['sgm.service_object_id', 'so.object_id'];
```

But I think the committed solution is better.

Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
2018-07-18 15:50:37 +02:00
Eric Lippmann
4b80b3e7ee IdoQuery: Support & and != for subquery filters
refs #2934
2018-07-18 15:50:37 +02:00