tyler.durden/icingaweb2
1
0
Fork 0
mirror of https://github.com/Icinga/icingaweb2.git synced 2025-07-08 22:44:24 +02:00
Code Issues Packages Projects Releases Wiki Activity
13,960 Commits 125 Branches 75 Tags
Commit Graph

819 Commits

Author SHA1 Message Date
Johannes Meyer
5c8cf64658 IdoQuery: Use subqueries to filter linked objects 
refs #2934

Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
 2018-07-18 15:50:37 +02:00
Alexander A. Klimov
0b5620d2b5 Fetch check_interval property of monitored objects, too 2018-07-18 15:42:34 +02:00
Eric Lippmann
d5d336884c Fix grouping in the new contact queries 
refs #3088
 2018-07-18 15:20:23 +02:00
Johannes Meyer
5befab6a2b ContactQuery: Don't use a UNION query if not necessary 
Speeds up the db's response time significantly in huge
environments.

refs #3088

Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
 2018-07-18 15:20:23 +02:00
Eric Lippmann
e684c6d18e Split contact query into subqueries 
One can't fetch host and service contacts with a reasonable single
query.

refs #3088
 2018-07-18 15:20:23 +02:00
Eric Lippmann
ea722484b0 Introduce 'problems' columns for CLI usage 
refs #3512
 2018-07-09 16:10:07 +02:00
Johannes Meyer
4ec783b75e IdoQuery: Use a dynamic collation when joining custom variables 
refs #2508
 2018-04-27 15:33:42 +02:00
Johannes Meyer
1c29b03b84 Revert "Merge pull request #3413 from Icinga/bugfix/filter-contacts-assigned-to-services-3088" 
This reverts commit 33247237afc2691463e82e889e49fe735177e186, reversing
changes made to 37aeb83cd92ee74c0e5481aa58fc0084c18d4978.

refs #3436
 2018-04-27 10:13:58 +02:00
Alexander A. Klimov
bbca113adc IDO: treat contacts of services of hosts as direct contacts of the hosts 
refs #3088
 2018-04-06 15:16:36 +02:00
Alexander A. Klimov
4995df8336 Make host and service groups sortable by the members' severities 
refs #3395
 2018-04-04 10:05:27 +02:00
Johannes Meyer
b07e4b409f EventHistory: Drop obsolete SUM aggregates 
Not used anywhere and not working for a long time already,
at least as filter columns.

refs #2860
 2018-01-17 12:41:10 +01:00
lippserd
6abb91421a
Merge pull request #3220 from Icinga/fix/filter-by-custom-variables 
Fix filter by host custom variables
 2018-01-11 11:40:22 +01:00
Alexander A. Klimov
196cdbe4af Implement event history detail view 
refs #3191
 2018-01-09 13:04:06 +01:00
Eric Lippmann
93ec798c6b Ido: Map h.host_object_id to s.host_object_id in the ServicegroupQuery 
This is required to make filters work which filter by host custom variables without using any host related table.
 2017-12-18 10:35:16 +01:00
Eric Lippmann
b1f7923711 Ido: Allow custom variables to be mapped 
If you filter by host custom variables and the query does not have the services table joined,
our query implementation calls the joinHosts method. Then, the column for the JOIN ON condition is
automatically set to h.host_object_id.
But it may be required by the query to call joinServices and use s.host_object_id instead of
h.host_object_id because the query does not use any host related table at all.

This is now possible when h.host_object_id is mapped to s.host_object_id:

class ServicesRelatedQuery
{
    protected $columnMap = array(
        'hosts' => array(
            'h.host_object_id' => 's.host_object_id'
        )
    );

    protected function joinHosts()
    {
        $this->requireVirtualTable('services');
    }
}
 2017-12-18 10:23:45 +01:00
lippserd
a5bf9e0175
Merge pull request #3029 from Icinga/bugfix/empty-host-and-service-groups-not-shown-2796 
Bugfix/empty host and service groups not shown 2796
 2017-11-27 14:24:11 +01:00
Eric Lippmann
d11519ac49 pogsql: Group by custom variables when querying them 
Custom variables added via the URL parameters addColumns or sort must be added to the GROUP BY list when using PostgreSQL.

Credits to @nbuchwitz who came up with the initial fix for this.

refs #1873
 2017-11-16 09:20:22 +01:00
Johannes Meyer
23066d2cc4 ServicegroupQuery: Use left joins instead of inner joins 
refs #2796
 2017-11-09 09:42:46 +01:00
Johannes Meyer
4ef085bdcd HostgroupQuery: Use left joins instead of inner joins 
refs #2796
 2017-11-09 09:42:46 +01:00
Eric Lippmann
121fdaadb0 Allow to search for host and servicegroups by their case insensitive names too 
refs #2971
 2017-11-08 15:40:43 +01:00
Eric Lippmann
8de0b80f9e Fix contact group member count 
fixes #2837
 2017-10-05 14:35:15 +02:00
Michael Friedrich
ab364e0fc7 Remove unsupported livestatus functionality 
Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
 2017-09-29 10:33:55 +02:00
Jennifer Mourek
0b30fbd15d Adjust host severity 
refs #2926

Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
 2017-09-25 17:03:33 +02:00
Eric Lippmann
adc2f90f74 Show DOWN hosts before UNREACHABLE when sorting by host_severity 
refs #2034
 2017-07-27 16:08:29 +02:00
Eric Lippmann
e7776d08a9 Don't call UNIX_TIMESTAMP when sorting by host_last_state_change 
Else possible indices can't be used.
 2017-07-27 15:03:12 +02:00
Eric Lippmann
3a1afb3511 Don't call UNIX_TIMESTAMP when sorting by service_last_state_change 
Else possible indices can't be used.
 2017-07-27 15:03:12 +02:00
Eric Lippmann
9b529bcd15 Flip base tables in HoststatusQuery 
This has no performance impact but all our queries should start w/ select from icinga_objects.
 2017-07-27 15:03:12 +02:00
Eric Lippmann
370d148072 Optimize imports in HoststatusQuery 2017-07-27 15:03:12 +02:00
Eric Lippmann
b4df81e75a Optimize queries used for fetching the service group summaries 2017-07-27 15:03:12 +02:00
Eric Lippmann
06cb980308 Don't add GROUP BY for unjoined tables 2017-07-27 15:03:12 +02:00
Eric Lippmann
30cc51a823 Optimize queries used for fetching the host group summaries 
refs #1883
 2017-07-27 11:43:13 +02:00
Eric Lippmann
f5a9016dea Optimize queries for creating the host and service problem badges in the menu 
We now use two fast count queries w/ an appropriate filter instead of fetching a whole bunch of unnecessary host and service counters.
 2017-07-27 11:38:00 +02:00
Eric Lippmann
a4a0f9f5e6 Allow to filter notifications by notification_reason 
refs #2698
 2017-05-04 14:38:00 +02:00
Alexander A. Klimov
95020bfed4 Show check attempts only for soft state changes 
refs #2718
 2017-02-08 14:09:18 +01:00
Johannes Meyer
181e2ef05c Swag: Fix swag (aka a whole bunch of code style issues..) 2017-01-27 14:48:59 +01:00
Michael Friedrich
b474482188 Fix local timestamp for PostgreSQL queries 
This fixes the "monitoring health" view indicating that Icinga 2
isn't updating the database, even if status_update_time uptodate.

refs #2651

Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
 2017-01-17 16:31:03 +01:00
Eric Lippmann
8f9920f1fc Return unprefixed Icinga version in MonitoringBackend::getProgramVersion() 2016-12-12 12:40:54 +01:00
Eric Lippmann
62ebaab8b7 Merge branch 'feature/show-flapping-events-in-the-history-views-12766' 
resolves #12766
 2016-12-12 10:57:25 +01:00
Alexander A. Klimov
665557be27 Support Icinga 2.6 IDO w/ PostgreSQL 2016-12-09 11:57:56 +01:00
Alexander A. Klimov
efed4a34a1 Event history: show also flapping events 
refs #12766
 2016-12-07 17:23:20 +01:00
Eric Lippmann
d6d0434a5f Merge remote branch 'bugfix/show-all-usergroups-in-the-web-interface-11744' 
fixes #11744
 2016-12-05 11:18:18 +01:00
Alexander A. Klimov
a0a203c875 Make timeline working again 
refs #12889
 2016-10-17 12:44:05 +02:00
Eric Lippmann
c547f4c17f Fix error in the contact detail view introduced by changes to the notification queries 2016-09-15 14:07:19 +02:00
Eric Lippmann
fd6ae75803 IDO: Improve notification view performance 2016-09-14 16:18:41 +02:00
Eric Lippmann
1ed2ebc191 IDO: Add config option to use the customvariables table for fetching custom vars 
Icinga 1.x has the option to not dump the icinga_customvariablestatus table:

dump_customvar_status=0

With this setting applied, Web 2 will never show custom variables because Web 2 relies on the customvariablestatus table.
This commit introduces a config option to use the customvariables table instead:

/etc/icingaweb2/modules/monitoring/config.ini

[ido]
use_customvar_status_table = 0
 2016-09-12 15:52:07 +02:00
Eric Lippmann
65d7c18c31 Merge branch 'bugfix/contact-service-filter-12019' 
fixes #12019
 2016-09-12 12:30:34 +02:00
Eric Lippmann
c55c5a9e64 IDO: Provide downtime name column 
The Icinga 2 API requires the downtimes's name when removing the downtime.

refs #11398
 2016-08-31 14:05:01 +02:00
Eric Lippmann
0e307c6482 IDO: Provide comment name column 
The Icinga 2 API requires the comment's name when removing the comment.

refs #11398
 2016-08-31 12:57:50 +02:00
Michael Friedrich
f127611969 Fix contact service filters for 'Downtime' 
refs #12019
 2016-06-22 13:32:26 +02:00
Alexander A. Klimov
3fed5e920f list/contactgroups: show empty usergroups, too 
refs #11744
 2016-05-31 17:55:52 +02:00