382 Commits

Author SHA1 Message Date
Johannes Meyer
ec27f77861 DataView: Relax filter validation again
There are way too much missing columns in data views all
over the place. I dont' see a justification to fix them
as it's only now this "issue" occurs. It's easier to
revert this change here.

fixes #4797
2022-06-14 15:32:21 +02:00
Sukhwinder Dhillon
4ab79a6758 DataView: Remove not in use method applyUrlFilter() 2022-06-14 14:24:30 +02:00
Sukhwinder Dhillon
577d97a450 DataView: Move sort() body to order() and remove sort() and fromRequest() 2022-06-14 14:24:30 +02:00
raviks789
8898ed85ab Change FilterMatch to FilterEqual class for single object filter on object name.
Correspondingly the DbConnection::renderFilter() (as DbQuery::renderFilter() is deprecated and will be removed, hence no modifications here)
is also modified to render accordingly.
This correctly selects the host, service or contact in case the object name contains wild card characters like "\*".
2022-05-12 16:28:35 +02:00
Johannes Meyer
3edb5c3c94 IdoQuery: Introduce method whereEx() 2022-05-12 16:28:35 +02:00
Johannes Meyer
c038e84fc2 Ensure Return Type Compatibility with Internal Classes 2022-03-24 12:29:06 +01:00
Johannes Meyer
a240e306ed Preserve/Remove param showCompact instead of view 2020-06-04 08:50:41 +02:00
Johannes Meyer
d6a630432e Servicegroupsummary: Only provide valid filter columns
refs #3940
2019-09-26 13:48:49 +02:00
Johannes Meyer
2b77baa19f Hostgroupsummary: Only provide valid filter columns
refs #3940
2019-09-26 13:47:56 +02:00
Eric Lippmann
bcc867d48e Allow to filter for contact groups 2019-07-29 09:12:01 +02:00
Eric Lippmann
523a35f4c1 Allow to filter for contacts 2019-07-08 18:00:28 +02: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
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
Johannes Meyer
2fbbf3da58 DataView\Contact: Make instance_name a static filter column
It's not queryable by its accompaniying query.

refs #3088
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
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
Alexander A. Klimov
196cdbe4af Implement event history detail view
refs #3191
2018-01-09 13:04:06 +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
7c88ee70d2 Remove sort rules from Programstatus
Sort is not necessary here.
2017-07-27 15:03:12 +02:00
Eric Lippmann
1621755103 Don't call UNIX_TIMESTAMP when sorting by host_severity 2017-07-27 15:03:12 +02:00
Eric Lippmann
9b7a155db2 Don't call UNIX_TIMESTAMP when sorting by service_severity 2017-07-27 15:03:12 +02:00
Eric Lippmann
8a6240fe02 Reduce service_severity order by columns
Ordering by host and service display_name too here reduces performance and is not necessary.
2017-07-27 15:03:12 +02:00
Eric Lippmann
c5f2fc5aa5 Reduce service_display_names order by columns
Ordering by host_display_name too here reduces performance as it forces MySQL to use a temp table.
2017-07-27 15:03:12 +02:00
Eric Lippmann
ee429f54d0 Reduce host_severity order by columns
Ordering by host_display_name too here reduces performance and is not necessary.
2017-07-27 15:03:12 +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
e42d86a4e1 Remove unncessary column definitions in the Hostgroupsummary and Servicegroupsummary data views 2017-07-27 15:03:12 +02:00
Eric Lippmann
0a3da99e7f Reduce filter columns of the Hostgroup and Servicegroup data views
Its not necessary to expose those columns because these data views do not directly accept user input.
2017-07-27 15:03:12 +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
Johannes Meyer
181e2ef05c Swag: Fix swag (aka a whole bunch of code style issues..) 2017-01-27 14:48:59 +01:00
Johannes Meyer
8978ad9f79 Revert "DataView: Apply object restrictions to dynamic filter columns"
This reverts commit 9ec471d34965198d2cfd5f2b9a6bbb76883023e0.

refs #9993
2016-11-15 12:47:54 +01:00
Noah Hilverling
9ec471d349 DataView: Apply object restrictions to dynamic filter columns
fixes #9993
2016-10-17 09:17:49 +02:00
Eric Lippmann
fd6ae75803 IDO: Improve notification view performance 2016-09-14 16:18:41 +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
Eric Lippmann
4cc4657ee9 Add host_is_reachable column to the host status data view
refs #11404
2016-04-11 10:29:26 +02:00
Eric Lippmann
750b8950b2 lib: Reorder columns in Hoststatus 2016-04-11 10:29:08 +02:00
Eric Lippmann
a824637c0e Add service_is_reachable column to the service status data view
refs #11404
2016-04-11 10:28:12 +02:00
Eric Lippmann
aced4f3b6e lib: Reorder columns in Servicestatus 2016-04-11 10:27:28 +02:00
Eric Lippmann
a2ff8c9778 monitoring: No longer provide contact columns in the contact group query
Contacts query w/ filter for contact group should be used instead.
2016-03-31 10:26:27 +02:00
Marius Hein
c831bc5232 Add host_alias to search columns if backend is icinga 1 2016-02-29 22:34:54 +01:00
Eric Lippmann
7f358ed88d Don't sort a data view on dump when the data view is already sorted 2016-02-23 15:40:40 +01:00
Alexander A. Klimov
474803fee4 Change all license headers to only reflect a file's year of creation
refs #11000
2016-02-08 15:41:00 +01:00
Eric Lippmann
d7eaa41ab4 Move sort services by last state change up in the sort by list
refs #9957
2015-12-21 10:33:21 +01:00
Alexander A. Klimov
2624c7f328 Sort hosts and services descending by last state change
refs #9957
2015-12-18 15:50:57 +01:00
Thomas Gelf
0e709d5469 DataViewHost/Servicestatus: use hooked columns 2015-11-13 17:37:02 +01:00
Thomas Gelf
f3cb1f915d Monitoring/DataView: allow to hook in columns 2015-11-13 17:37:02 +01:00