Module: nagvis Branch: master Commit: 53c615050e60cdc2913ccbe2367e7a4785f750b3 URL: http://nagvis.git.sourceforge.net/git/gitweb.cgi?p=nagvis/nagvis;a=commit;h=53c615050e60cdc2913ccbe2367e7a4785f750b3
Author: Lars Michelsen <[email protected]> Date: Sun Apr 25 01:49:12 2010 +0200 Fixed hostgroup ack detection --- share/server/core/classes/GlobalBackendndomy.php | 22 +++++++++++----------- 1 files changed, 11 insertions(+), 11 deletions(-) diff --git a/share/server/core/classes/GlobalBackendndomy.php b/share/server/core/classes/GlobalBackendndomy.php index e5c8a42..c643933 100644 --- a/share/server/core/classes/GlobalBackendndomy.php +++ b/share/server/core/classes/GlobalBackendndomy.php @@ -850,17 +850,17 @@ class GlobalBackendndomy implements GlobalBackendInterface { $QUERYHANDLE = $this->mysqlQuery('SELECT o.name1, SUM(IF(hs.has_been_checked=0,1,0)) AS pending, - SUM(IF((hs.'.$stateAttr.'=0 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0 AND hs.scheduled_downtime_depth=0),1,0)) AS up, - SUM(IF((hs.'.$stateAttr.'=0 AND hs.has_been_checked!=0 AND (hs.scheduled_downtime_depth!=0 OR hs.scheduled_downtime_depth!=0)),1,0)) AS up_downtime, - SUM(IF((hs.'.$stateAttr.'=1 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0 AND hs.scheduled_downtime_depth=0),1,0)) AS down, - SUM(IF((hs.'.$stateAttr.'=1 AND hs.has_been_checked!=0 AND (hs.scheduled_downtime_depth!=0 OR hs.scheduled_downtime_depth!=0)),1,0)) AS down_downtime, - SUM(IF((hs.'.$stateAttr.'=1 AND hs.has_been_checked!=0 AND (hs.problem_has_been_acknowledged=1 OR hs.problem_has_been_acknowledged=1)),1,0)) AS down_ack, - SUM(IF((hs.'.$stateAttr.'=2 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0 AND hs.scheduled_downtime_depth=0),1,0)) AS unreachable, - SUM(IF((hs.'.$stateAttr.'=2 AND hs.has_been_checked!=0 AND (hs.scheduled_downtime_depth!=0 OR hs.scheduled_downtime_depth!=0)),1,0)) AS unreachable_downtime, - SUM(IF((hs.'.$stateAttr.'=2 AND hs.has_been_checked!=0 AND (hs.problem_has_been_acknowledged=1 OR hs.problem_has_been_acknowledged=1)),1,0)) AS unreachable_ack, - SUM(IF((hs.'.$stateAttr.'=3 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0 AND hs.scheduled_downtime_depth=0),1,0)) AS unknown, - SUM(IF((hs.'.$stateAttr.'=3 AND hs.has_been_checked!=0 AND (hs.scheduled_downtime_depth!=0 OR hs.scheduled_downtime_depth!=0)),1,0)) AS unknown_downtime, - SUM(IF((hs.'.$stateAttr.'=3 AND hs.has_been_checked!=0 AND (hs.problem_has_been_acknowledged=1 OR hs.problem_has_been_acknowledged=1)),1,0)) AS unknown_ack + SUM(IF((hs.'.$stateAttr.'=0 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0),1,0)) AS up, + SUM(IF((hs.'.$stateAttr.'=0 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth!=0),1,0)) AS up_downtime, + SUM(IF((hs.'.$stateAttr.'=1 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0 AND hs.problem_has_been_acknowledged=0),1,0)) AS down, + SUM(IF((hs.'.$stateAttr.'=1 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth!=0),1,0)) AS down_downtime, + SUM(IF((hs.'.$stateAttr.'=1 AND hs.has_been_checked!=0 AND hs.problem_has_been_acknowledged=1),1,0)) AS down_ack, + SUM(IF((hs.'.$stateAttr.'=2 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0 AND hs.problem_has_been_acknowledged=0),1,0)) AS unreachable, + SUM(IF((hs.'.$stateAttr.'=2 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth!=0),1,0)) AS unreachable_downtime, + SUM(IF((hs.'.$stateAttr.'=2 AND hs.has_been_checked!=0 AND hs.problem_has_been_acknowledged=1),1,0)) AS unreachable_ack, + SUM(IF((hs.'.$stateAttr.'=3 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth=0 AND hs.problem_has_been_acknowledged=0),1,0)) AS unknown, + SUM(IF((hs.'.$stateAttr.'=3 AND hs.has_been_checked!=0 AND hs.scheduled_downtime_depth!=0),1,0)) AS unknown_downtime, + SUM(IF((hs.'.$stateAttr.'=3 AND hs.has_been_checked!=0 AND hs.problem_has_been_acknowledged=1),1,0)) AS unknown_ack FROM '.$this->dbPrefix.'objects AS o, '.$this->dbPrefix.'hostgroups AS hg, ------------------------------------------------------------------------------ _______________________________________________ Nagvis-checkins mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/nagvis-checkins
