zabbix告警页面sql语句

 zabbix告警列表的sql语句。

select b.priority bpriority,concat(f.groupid,'') as hstgrpId,concat(e.hostid,'') as hostid,e.name hostName,a.name errMsg from (  
		select * from problem p   
		where p.r_eventid is null and p.source =0 and p.object=0 and  p.severity in (3, 4, 5)   
		and NOT EXISTS (  
			select 1 FROM functions f,items i,hosts_groups hgg  
			left JOIN rights r ON r.id=hgg.groupid and r.groupid=13  
			WHERE p.objectid=f.triggerid  
			AND f.itemid=i.itemid  
			AND i.hostid=hgg.hostid  
			GROUP BY i.hostid  
			HAVING MAX(permission) < 2  
			OR MIN(permission) IS NULL  
			OR MIN(permission)= 0 )  
		and not exists(  
			select 1 from acknowledges a WHERE p.eventid=a.eventid  )  
        order by p.name desc  
) a inner join  (  
		select * from triggers t   
		where not exists(  
			SELECT 1  
			FROM functions f,items i,hosts h   
			WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid  
			AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)  
		) and t.status= 0  
) b on b.triggerid = a.objectid  
inner join functions c on b.triggerid=c.triggerid  
inner join items d on c.itemid=d.itemid  
inner join hosts e on d.hostid=e.hostid  
inner join hosts_groups f on f.hostid=d.hostid  
where b.priority>=3

其中bpriority严重程度的枚举值：

      0  Not classified
      1  Information
      2  Warning
      3  Average
      4  High
      5  Disaster