From c251e5c034c00b9b3a1fd21ef727f0c196404c23 Mon Sep 17 00:00:00 2001 From: osmiy Date: Mon, 19 Mar 2007 09:49:38 +0000 Subject: - fixed events.triggerid requests git-svn-id: svn://svn.zabbix.com/trunk@3896 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/report5.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'frontends/php/report5.php') diff --git a/frontends/php/report5.php b/frontends/php/report5.php index 75da6155..c27e506a 100644 --- a/frontends/php/report5.php +++ b/frontends/php/report5.php @@ -69,8 +69,8 @@ include_once "include/page_header.php"; $result=DBselect("select h.host, t.triggerid, t.description, t.priority, count(distinct e.eventid) as count ". " from hosts h, triggers t, functions f, items i, events e where ". " h.hostid = i.hostid and i.itemid = f.itemid and t.triggerid=f.triggerid and ". - " t.triggerid=e.triggerid and e.clock>".(time()-$time_dif). - " and h.hostid in (".$accessible_hosts.") and ".DBid2nodeid("e.triggerid")."=".$ZBX_CURNODEID. + ' t.triggerid=e.objectid and e.object='.EVENT_OBJECT_TRIGGER.' and e.clock>'.(time()-$time_dif). + " and h.hostid in (".$accessible_hosts.") and ".DBid2nodeid("t.triggerid")."=".$ZBX_CURNODEID. " group by h.host,t.triggerid,t.description,t.priority ". " order by count desc, h.host, t.description, t.triggerid", 100); -- cgit