Zabbix Cleanup From Hanging Triggers Items

From UVOO Tech Wiki
Jump to navigation Jump to search
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%';
delete from items where name like 'Interface Intel(R) 82574L Gigabit Network Connection%';

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)