diff options
Diffstat (limited to 'frontends/php/report2.php')
| -rw-r--r-- | frontends/php/report2.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/frontends/php/report2.php b/frontends/php/report2.php index 10eee4c5..e534f733 100644 --- a/frontends/php/report2.php +++ b/frontends/php/report2.php @@ -26,7 +26,7 @@ <? - $result=DBselect("select h.hostid,h.host,t.triggerid,t.expression,t.description,t.value from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.status=0 and t.triggerid=f.triggerid and h.status in (0,2) and i.status=0 order by h.host,t.lastchange desc, t.description"); + $result=DBselect("select distinct h.hostid,h.host,t.triggerid,t.expression,t.description,t.value from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.status=0 and t.triggerid=f.triggerid and h.status in (0,2) and i.status=0 order by h.host, t.description"); $lasthost=""; $col=0; |