zabbix告警页面sql语句

最新推荐文章于 2023-03-30 02:39:04 发布

罗雀儿

最新推荐文章于 2023-03-30 02:39:04 发布

阅读量1.8k

点赞数

分类专栏： SQL 文章标签： sql zabbix sql

本文链接：https://blog.csdn.net/qq_22165667/article/details/121269843

版权

SQL 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

该博客详细介绍了用于获取Zabbix告警列表的SQL查询语句，重点关注未被确认且状态正常的严重级别在警告以上的事件。查询涉及到触发器、函数、物品、主机和主机组等多个表的联接操作，同时排除了权限不足和已确认的告警。告警严重程度从0到5，分别代表未分类、信息、警告、平均、高和灾难级别。

摘要由CSDN通过智能技术生成

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