Alert rule doesn't respect condition

Help
1

Can anyone explain why this alert rule doesn’t respect condition ifDescr != ?

SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND ports.ifDescr != “IP interface”

I’m having this annoying issue with ip interface where they are reporting wrong utilization. I already tried rrdtune but it doesn’t help. I thought i could filter it out with alert rule

2

Solved.

Instead of

ports.ifDesc

i had to use

ports.port_descr_type

to filter out unwanted interface in this case.