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
