Zabbix数据库快速查询sql语句（持续更新）
1、通过应⽤值查询某个监控历史趋势数据（application：system.cpu.util[,user]，hostname:Zabbix server）
浮点类型数据：select * from trends where itemid in (select itemid from items where key_ like 'system.cpu.util[,user]' and hostid in (select hostid from hosts where host = 'Zabbix server'));
长整型数据：
select * from trends_uint where itemid in (select itemid from items where key_ like 'system.cpu.util[,user]' and hostid in (select hostid from hosts where host = 'Zabbix server'));
2、通过Action 发送次数查询具体的Action名称（发送次数：esc_step_to）
select name from actions where actionid in (select actionid from operations where esc_step_to =2);
批量更新sql语句3、批量更新主机可见名（以组名(server)区分）：
update hosts set name = concat(name,'【管理员主机】') where hostid in (select hostid from hosts_groups where groupid in (select groupid from groups where name='server'));