zabbix 使用小技巧
001、监控项指定时间执行
wd1-7h01m00 周一到周日,每天 01:00:00 执行一次
002、监控项某一段时间点每分钟执行一次
1-5,00:00-09:00
6-7,00:00-23:59
003、查看新建监控的值
等我们新建了一个监控项<system.run[sudo md5sum /etc/hosts.allow|grep 711ae8a55cb7013d9bcea47cbd8547a4|wc -l]>,想要获取到对应值的时候
select distinct b.host,c.value from items a, hosts b, history_str c where a.hostid=b.hostid and a.itemid=c.itemid and key_='system.run[sudo md5sum /etc/hosts.allow|grep 711ae8a55cb7013d9bcea47cbd8547a4|wc -l]' and value='0';
history_str:字符
select b.* from items a, hosts b, history_uint c where a.hostid=b.hostid and a.itemid=c.itemid and key_='system.cpu.num' limit 1\G
数字(无正负):history_uint
文本:history_text
004、zabbix表介绍
https://www.cnblogs.com/yaoyaojcy/p/10367945.html
005、获取所有主机某个触发器的id信息
select distinct a.name,e.ip,d.triggerid,d.description,d.status,d.priority from hosts a, items b, functions c, triggers d, interface e where a.hostid=b.hostid and b.itemid=c.itemid and c.triggerid=d.triggerid and a.hostid=e.hostid and d.description='Netdata no Install' and a.name in ('主机名1','主机名2');