diff options
Diffstat (limited to 'frontends/php/report2.html')
-rw-r--r-- | frontends/php/report2.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/frontends/php/report2.html b/frontends/php/report2.html index 2011ac7d..6582199e 100644 --- a/frontends/php/report2.html +++ b/frontends/php/report2.html @@ -26,7 +26,7 @@ <? - $result=DBselect("select h.hostid,h.host,t.triggerid,t.expression,t.description,t.istrue from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.istrue!=2 and t.triggerid=f.triggerid order by h.host,t.description"); + $result=DBselect("select h.hostid,h.host,t.triggerid,t.expression,t.description,t.istrue from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.istrue!=2 and t.triggerid=f.triggerid and h.status=0 order by h.host,t.description"); $lasthost=""; $col=0; for($i=0;$i<DBnum_rows($result);$i++) |