tyler.durden/icingaweb2
1
0
Fork 0
mirror of https://github.com/Icinga/icingaweb2.git synced 2025-09-24 18:37:52 +02:00
Code Issues Packages Projects Releases Wiki Activity
13,330 Commits 132 Branches 76 Tags
Commit Graph

757 Commits

Author SHA1 Message Date
Johannes Meyer
fda5a5970d IdoQuery: Join customvars with only live references 2022-02-28 13:39:56 +01:00
Johannes Meyer
59fadd863a Ido\Query\: Add objecttype_id checks where missing 2022-02-28 13:39:56 +01:00
Johannes Meyer
62a27fa638 IdoQuery: Qualify and resolve subquery filters ASAP 
fixes #4508

(cherry picked from commit 83557afd35dc85da01995be2a907f9223fb0bb84)
 2021-11-09 09:32:08 +01:00
Johannes Meyer
4318b054cc ServicestatusQuery: Define correct grouping rules for contacts and -groups 
fixes #4464

(cherry picked from commit b94617c5756dd7fd883869b90dc705f303cd3e41)
 2021-07-21 17:42:16 +02:00
Johannes Meyer
963fdbd3e2 ServicegroupQuery: Join hostgroups with a LEFT JOIN 
refs #4404
 2021-07-05 14:59:24 +02:00
Johannes Meyer
13125e8059 HostgroupQuery: Join services and servicegroups with a LEFT JOIN 
refs #4404
 2021-07-05 14:58:49 +02:00
Alexander A. Klimov
6d5024c671 *downtimestarthistoryQuery#joinBaseTables(): don't call func_get_arg() with an invalid index 
... as PHP 8 doesn't tolerate that.

refs #4287
 2021-04-09 12:37:03 +02:00
Johannes Meyer
fe51f8c968 IdoQuery: Accept any character in custom var names 
fixes #4342
 2021-04-06 10:47:03 +02:00
Johannes Meyer
0fc06d7795 Transform * equal/unequal comparisons to NULL checks 
This comes from https://github.com/Icinga/ipl-sql/pull/31
 2021-03-12 09:50:59 +01:00
Johannes Meyer
b01bd74d5c ServicestatusQuery: Join contactgroups with the correct type id 2020-11-16 13:18:28 +01:00
Johannes Meyer
459e61ba55 ServicegroupQuery: Join contactgroups with the correct type id 2020-11-16 13:18:28 +01:00
Johannes Meyer
fbacd3db36 list/services: Avoid duplicates when filtering contact(group)s 
fixes #4238
 2020-11-16 13:17:32 +01:00
Johannes Meyer
0db4dc0311 IdoQuery: Force array cast when lowering subquery filter expressions 
fixes #4196
 2020-07-06 08:34:40 +02:00
Johannes Meyer
4505e29ce3 IdoQuery: Lowercase subquery ci filters on postgres 
fixes #4178
 2020-06-16 09:59:19 +02:00
Thomas Gelf
bdea1bfd47 Query\*notificationQuery: add missing host_alias 
Fixes an Exception when searching for a specific alias (as offered in
the filter form)
 2020-05-04 12:26:49 +02:00
Johannes Meyer
ded92c786a Add missing columns to empty group queries 2019-10-18 07:32:58 +02:00
Johannes Meyer
8e51518e96 ServicegroupQuery: Really join hosts if instructed to do so 
fixes #3983
 2019-10-17 16:14:28 +02:00
Johannes Meyer
908c408d3d ServicegroupsummaryQuery: Fetch empty groups with a union query 
refs #3928
 2019-10-11 10:27:43 +02:00
Johannes Meyer
faca6d53c8 HostgroupsummaryQuery: Add empty groups to the union 
refs #3928
 2019-10-11 10:27:43 +02:00
Johannes Meyer
fae60f06bf Revert "Show empty groups with a filter chain too" 
This reverts commit fadf12e98a5f612f4475ea7c49d0eec46dffc7de.
 2019-10-08 13:39:52 +02:00
Johannes Meyer
0e729bb85b Revert "ServicegroupQuery: Use left joins instead of inner joins" 
This reverts commit 23066d2cc4308bf66cb1600c68cee12479b1a0c7.
 2019-10-08 13:39:52 +02:00
Johannes Meyer
94b0689b95 Revert "HostgroupQuery: Use left joins instead of inner joins" 
This reverts commit 4ef085bdcd55b24deeac071fd65363da35585ac0.
 2019-10-08 13:39:52 +02:00
Johannes Meyer
c21867699a ServicestatusQuery: Adjust next_update calculation to respect next_check 2019-10-08 13:21:43 +02:00
Johannes Meyer
b9ea432d35 HoststatusQuery: Adjust next_update calculation to respect next_check 2019-10-08 13:21:43 +02:00
Eric Lippmann
fadf12e98a Show empty groups with a filter chain too 2019-08-14 11:50:14 +02:00
Eric Lippmann
214a34a5a8 Always use subquery filters for subquery targets in the group views 2019-08-13 17:18:50 +02:00
Eric Lippmann
7730058c2c Fix Event Grid PostgreSQL error 
PostgreSQL fails with failed to find conversion function from
unknown to text. PostgreSQL won't detect the type of object_type.
Most likely because it's used in a CASE statement and provided by a
subquery:

select case when s.object_type = 'service' then 1 else 0 end from
(select ('service') as object_type) as s;

This commit just removes object_type from the CASE statements because we
don't need them anyway. Recently we've changed the event grid query to
only select hosts or services and not both.
 2019-07-30 09:32:59 +02:00
Eric Lippmann
e61cb71c17 Use unique values for combined AND group membership filters 2019-07-30 09:17:25 +02:00
Eric Lippmann
0de923fc5f Support "old" combined group membership filter in subquery filter chains 2019-07-30 09:17:25 +02:00
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