Difference between revisions of "Zabbix Cleanup From Hanging Triggers Items"
Jump to navigation
Jump to search
Line 6: | Line 6: | ||
``` | ``` | ||
− | delete from items where hostid= | + | delete from items where name like '%Interface Microsoft Hyper-V%'; |
+ | delete from items where hostid=xxxx and name like '%Interface Microsoft Hyper-V%'; | ||
``` | ``` | ||
Revision as of 00:25, 1 August 2023
delete from items where (name not like '%DEVNAME%' and key_ like 'perf_counter_en%PhysicalDisk%') or (name not like '%DEVNAME%' and key_ like 'net.if.%vmxnet3 Ethernet Adapter%') and (name not like '% DEVNAME%');
delete from items where name like '%Interface Microsoft Hyper-V%'; delete from items where hostid=xxxx and name like '%Interface Microsoft Hyper-V%';
Notes
Interface Microsoft Hyper-V Network Adapter(Ethernet): Bits received Triggers 1 net.if.in["Microsoft Hyper-V Network Adapter"] 3m 7d 365d Zabbix agent (active) Enabled Application: Interface Microsoft Hyper-V Network Adapter(Ethernet) Interface Microsoft Hyper-V Network Adapter(Ethernet): Bits sent Triggers 1 net.if.out["Microsoft Hyper-V Network Adapter"] 3m 7d 365d Zabbix agent (active) Enabled Application: Interface Microsoft Hyper-V Network Adapter(Ethernet) Interface Microsoft Hyper-V Network Adapter(Ethernet): Inbound packets discarded net.if.in["Microsoft Hyper-V Network Adapter",dropped] 3m 7d 365d Zabbix agent (active) Enabled Application: Interface Microsoft Hyper-V Network Adapter(Ethernet) Interface Microsoft Hyper-V Network Adapter(Ethernet): Inbound packets with errors Triggers 1 net.if.in["Microsoft Hyper-V Network Adapter",errors] 3m 7d 365d Zabbix agent (active) Enabled Application: Interface Microsoft Hyper-V Network Adapter(Ethernet) Interface Microsoft Hyper-V Network Adapter(Ethernet): Outbound packets discarded net.if.out["Microsoft Hyper-V Network Adapter",dropped] 3m 7d 365d Zabbix agent (active) Enabled Application: Interface Microsoft Hyper-V Network Adapter(Ethernet) Interface Microsoft Hyper-V Network Adapter(Ethernet): Outbound packets with errors Triggers 1 net.if.out["Microsoft Hyper-V Network Adapter",errors] 3m 7d 365d Zabbix agent (active)