Difference between revisions of "Zabbix Cleanup From Hanging Triggers Items"

From UVOO Tech Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:
  
 
```
 
```
delete from items where hostid=14767 and name like '%Interface Microsoft Hyper-V%';
+
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%';
 
```
 
```
  

Latest revision as of 00:56, 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%';
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)