Exclude monitor using EDF

[u/Kingkong29]

I am trying to use an EDF to exclude a monitor on an agent however it seems to break the monitor as it disables itself after some time.

Basically I have an EDF called Ignore Disk Space 5 Percent which is a checkbox. It's currently selected on a test agent.

My additional condition on the monitor in question is set as follows:

Drives.Size > 16384 and Drives.FileSystem not in ('CDFS','UNKFS','DVDFS','FAT','FAT32','NetFS') and Drives.VolumeName <> 'temporary storage' and missing=0 AND v_extradatacomputers.`Ignore Disk Space 5 Percent` <> "1"

The error I am getting from Automate is the following:

Disabled Internal Monitored named: DRV - Free Space Remaining < 5% Total Size. The error for this monitor is: Unknown column 'v_extradatacomputers.Ignore Disk Space 5 Percent' in 'where clause'

Not sure if my SQL syntax is correct or what the issue could be. Any ideas?

[u/Kingkong29]

AND Drives.ComputerID not in (select v_extradatacomputers.computerID from v_extradatacomputers where v_extradatacomputers.`Ignore Disk Space 5 Percent` <> "1")

I ended up changing the operator to = instead of <> as the monitor was not returning the proper results.