tyler.durden/icingaweb2
1
0
Fork 0
mirror of https://github.com/Icinga/icingaweb2.git synced 2025-05-16 04:30:11 +02:00
Code Issues Packages Projects Releases Wiki Activity
13,656 Commits 122 Branches 75 Tags
Commit Graph

766 Commits

Author SHA1 Message Date
Johannes Meyer
4b60f87021 IdoQuery: Correct doc of method requireColumn() 2022-07-05 09:55:32 +02:00
Johannes Meyer
e5ec9a36f7 monitoring: Fix conversion rules for timestamps in various queries 2022-07-05 09:55:32 +02:00
Johannes Meyer
46a21d9709 Drop method DbQuery::whereToSql() 
It's been used by `DbQuery::renderFilter()` rather
exclusively. So if removing one, both need to go.
 2022-06-14 14:24:30 +02:00
Johannes Meyer
3edb5c3c94 IdoQuery: Introduce method whereEx() 2022-05-12 16:28:35 +02:00
Johannes Meyer
c5cf7abf0d IdoQuery: Avoid passing null to preg_replace() 
refs #4640
 2022-04-19 15:01:52 +02:00
Johannes Meyer
0d032989e6 Fix style issues in recent security fixes 2022-03-08 15:20:16 +01:00
Johannes Meyer
8779f9f175 IdoQuery: Join customvars with only live references 2022-02-28 13:08:05 +01:00
Johannes Meyer
1092421782 Ido\Query\: Add objecttype_id checks where missing 2022-02-28 13:07:17 +01:00
Johannes Meyer
796742f03d monitoring/list/hosts: Don't show unhandled service counts 
It has too much problems. It wasn't even visible since the
initial release, at least not if there were many results.
It being visible was more a case of chance than guarantee.
We now also identified a major issue with restrictions and
the way we can assemble queries here. In short, there are
too much technical difficulties that we deemed it not
worthwhile to keep.
 2022-02-25 17:09:13 +01:00
Johannes Meyer
2e9a94144f HostserviceproblemsummaryQuery: Don't clear order of the host status query 2022-02-25 17:08:39 +01:00
Johannes Meyer
a4d34e265f IdoQuery: Don't try to add a HAVING without group by rules 2022-02-11 12:11:40 +01:00
Johannes Meyer
83557afd35 IdoQuery: Qualify and resolve subquery filters ASAP 
fixes #4508
 2021-08-24 09:32:36 +02:00
Johannes Meyer
b94617c575 ServicestatusQuery: Define correct grouping rules for contacts and -groups 
fixes #4464
 2021-07-21 17:41:55 +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