819 Commits

Author SHA1 Message Date
Johannes Meyer
cbadaa78d6 Merge branch 'master' into feature/setup-wizard-7163 2014-09-29 15:35:52 +02:00
Thomas Gelf
d7f8a7823f GroupsummaryQuery: adjust queries to fix ZF woes
Some less brackets also here. Dropping COALESCE as the subquery will
never return NULL

fixes #7303
2014-09-24 19:50:43 +02:00
Thomas Gelf
98fa84bd17 StatusSummaryQuery: one more quickfix
Tactical overview works again right now

refs #7303
2014-09-24 19:47:02 +02:00
Thomas Gelf
45fc768813 StatusSummaryQuery: workaround for silly ZF fix
This brings the tiny summaries back. Host- and servicegroups and TO are
still broken.

refs #7303
2014-09-24 19:33:05 +02:00
Johannes Meyer
c00dbf9f46 Write session on response
There should not be any necessity to write the session once changes are
being made to it. We now track whether changes were made and write
the session when responding to the user's request if so.
2014-09-24 10:46:35 +02:00
Eric Lippmann
cde3ec6bc8 Merge branch 'master' into bugfix/commands-6593
Conflicts:
	modules/monitoring/application/controllers/TimelineController.php
2014-09-23 22:54:17 -07:00
Matthias Jentsch
44e5fe7e12 Join Host and Servicegroups for extended filtering 2014-09-19 17:41:44 +02:00
Eric Lippmann
4b7096bbbf monitoring: Support host and service filters for downtimes
refs #7278
2014-09-19 14:28:23 +02:00
Marius Hein
9c2cf0bd0f StateHistoryQuery: Make whereToSql robust
This fixes bugs is a array for expression comes in or types
does not exist.

fixes #7133
2014-09-10 10:07:03 +02:00
Thomas Gelf
cbaa2d8ae9 StateHistoryQuery: tune type queries 2014-09-05 18:41:51 +02:00
Thomas Gelf
9ea377fd45 NotificationHistoryQuery: names instead of aliases
refs #7104
2014-09-05 18:16:59 +02:00
Thomas Gelf
38c6d6aaf8 StatusSummaryQuery: reorganize, add new columns
refs #6993
2014-09-05 18:16:58 +02:00
Thomas Gelf
1734f01040 CommentdeletionhistoryQuery: 1970-01-01 -> -02
refs #7000
2014-09-02 17:02:58 +02:00
Thomas Gelf
a58b2aac00 Ido\StatusQuery: join ALL latest comment
And it was soooo fast :p

refs #7057
2014-09-02 15:31:06 +02:00
Marius Hein
19136b548a StatusQuery: Separate last comment fields
fixes #7057
2014-09-02 13:57:43 +02:00
Thomas Gelf
6be31f4f51 Downtime*Query: use 1970-01-02 as "null"
refs #7000
2014-09-02 12:47:03 +02:00
Thomas Gelf
4a95b9d942 StatusSummaryQuery: respect pending, add columns 2014-09-02 12:45:15 +02:00
Thomas Gelf
153013bbc6 Ido\StatusQuery: pending hosts are not problems 2014-09-02 12:28:25 +02:00
Marius Hein
f47bc46654 GroupSummary/Postgres: Fix group by in initial join query
refs #5896
2014-09-01 10:00:04 +02:00
Marius Hein
21f0b4c925 CommandQuery: Remove select * from joins (Postgres)
refs #5896
2014-09-01 10:00:04 +02:00
Marius Hein
b4e9bad87a NotificationHistoryQuery: Add missing field to group statement
refs #5896
2014-09-01 10:00:04 +02:00
Marius Hein
e46dd4bdfd DowntimeQuery: Postgres fixes
Change is_fixed to boolean check and illegal postgres timerange of
'0000-00-00 00:00:00'.

refs #5896
2014-09-01 10:00:04 +02:00
Marius Hein
62f502d276 Postgres/StatusQuery: Fix concatenation and group by
refs #5896
2014-09-01 10:00:04 +02:00
Marius Hein
c4c5bcdd48 ContactQuery: Change timeperiod joins to joinLeft()
refs #7020
2014-08-28 13:39:49 +02:00
Marius Hein
5e84ff4ac4 Show/Contact: Add notification history to view
refs #4804
2014-08-27 16:38:29 +02:00
Marius Hein
9465c3ffb6 Show/Contact: Add commands to view
Create a new command query and join contact information into.

refs #4804
2014-08-27 16:38:29 +02:00
Alexander Klimov
45638b218c Throw IcingaException rather than Exception
fixes #7014
2014-08-27 16:03:15 +02:00
Alexander Klimov
7ff51caed0 Remove leading backslashes from the targets of use statements
- use \Exception;
+ use Exception;
2014-08-27 15:51:49 +02:00
Eric Lippmann
1dea19504f Revert "Remove leading backslashes from the targets of use statements"
This reverts commit 87a59675011a4cf284d8e44c4fb66042ad84c39f.

At least 'modules/doc/run.php' issues a warning about "The use statement with non-compound name 'Zend_Controller_Router_Route' has no effect"
2014-08-27 12:24:11 +02:00
Alexander Klimov
87a5967501 Remove leading backslashes from the targets of use statements
- use \Exception;
+ use Exception;
2014-08-27 11:16:44 +02:00
Alexander Klimov
febb2d1ae2 ProgrammingError: extend IcingaException
refs #6931
2014-08-26 11:15:19 +02:00
Johannes Meyer
3573908071 Let downtime view look more list-like and fix downtime end calculation
refs #6637
2014-08-19 17:03:35 +02:00
Johannes Meyer
54461f9319 Treat hard states more severe than soft states
fixes #6571
2014-08-15 12:40:56 +02:00
Johannes Meyer
3105c2059e Remove license headers from all files
refs #6309
2014-07-15 13:43:52 +02:00
Johannes Meyer
0d92efc1b0 Consider is_active column when fetching host and service statistics
fixes #6157
2014-07-09 11:49:22 +02:00
Johannes Meyer
7eb0f3c472 Remove @codingStandardsIgnoreStart/-Stop annotations
refs #6091
2014-06-30 13:59:58 +02:00
Thomas Gelf
ff9c29472e monitoring/status: re-introduce comments, problems
This re-introduces expensive columns been disabled time ago and adds
even more to it. We are now showing last comment, last ack comment and
service problem count on hosts in list views.

It still costs performance, but seems that we can stand it. I'd like
to add more like this to the host view.
2014-06-25 21:42:24 +02:00
Thomas Gelf
11ce302be0 Ido\StatusQuery: fine-tune query filters
This is still experimental. We normalize a lot of columns, this allows
us to sort in a convenient way while having nice "showable" columns.
When used as filters (same goes for ordering) however, functions and
operations on table columns often hinder the db from using indexes.

The new filter implementation allows us to override query creating per
single column, that's what this first sample is trying to show. We still
need to fix alias handling, so unfortunately I have to deal with "real
columns" in the case construct.

Performance gain in large environments is impressive, more to come.
2014-06-25 21:12:44 +02:00
Thomas Gelf
7b5d7bdbcf monitoring/statehistorysummary: filter fixes
Slightly adjusted filter string to fit new filters, fixed an issue
with 'object_type' column in virtual eventhistory table.
2014-06-21 03:18:00 +02:00
Thomas Gelf
b3cdeee35d monitoring/timeline: should benefit from new filter
Different changes have been applied:

* Allow integer unix timestamps as parameters for timestamp columns
* Remove alias-rewriting from Url class
* Remove all traces of raw_timestamp
* Use new filters
2014-06-21 03:09:40 +02:00
Thomas Gelf
a904ff51aa monitoring/eventhistory: improve query performance
This takes care of timestamp columns, modifies queries in a way not
depending on db functions, filters are passed through to subqueries
for better performance.
2014-06-20 19:14:34 +02:00
Thomas Gelf
ecf84077e5 Ido\CommentQuery: add host/service shortcut column 2014-06-20 12:23:23 +02:00
Thomas Gelf
8185f8b8a9 Ido\EventHistoryQuery: fix it to fit new filters
Works for single objects, still some work required for "generic"
history.
2014-06-17 14:02:54 +00:00
Thomas Gelf
dd595a2ad3 Ido/EventHistoryQuery: obsolete raw_timestamp
This was never thought to be used in frontends. Frontend code ALWAYS
needs to work with unix timestamps, raw timestamps are used internally
(e.g. between View and Query) to achieve better search and sort
performance.
2014-06-17 12:47:02 +00:00
Thomas Gelf
dab90d6c4a GroupsummaryQuery: distinct columns/desiredColumns
I guess this needs some more investigation, desiredColumns are the
ones the user asked for ([alias => ]column), with column being once
again an alias in the "real" query. Alias resolution used to work
better long time ago, we should reflect on this.
2014-06-17 12:42:50 +00:00
Thomas Gelf
027ef6ede3 Ido\Query\*historyQuery: subqueries join objects
Each of our history subqueries should be able to join main object
tables on their own for performance reasons.
2014-06-17 12:36:32 +00:00
Thomas Gelf
7cd696b31b Data/queries: adjust to fit new filters
Slight changes to get our queries working with new filter implementation.
2014-06-17 12:34:02 +00:00
Thomas Gelf
4c76f5ab02 Ido/Query: small fixes
Replaced baseQuery in ContactGroupQuery, added short host/service
columns to CustomvarQuery.
2014-06-13 10:44:03 +00:00
Thomas Gelf
e1421c0d7e Ido\StatusQuery: make sure performance killers...
...can no longer be reached. Column-ignorant uses still stumbled over
this. Left the code there as we should take a decision on how to approach
this.
2014-06-06 07:10:52 +00:00
Thomas Gelf
1c3ab74e80 IdoQuery: fit new DbQuery implementation
Just a bunch of small changes, more to come. Fixes customvar handling
and is now able to handle the new Filter implementation.

refs #6418
2014-06-06 06:57:28 +00:00