using SWQL to create a custom filter to exclude a specific drive

Question

Good day all,

I am working on creating a custom filter for a list of volumes to list only those of a specific group of servers whose volume utilization is greater than 80% but exclude one specific HD.  I have everything working except for the exclusion.  Here is the basic information:

SWQL Statement:   VolumeType LIKE 'Fixed%' AND VolumePercentUsed > 80

The drive I am trying to exclude is below:

Volume Details   Node ID 1194 VOLUME P:\ Label:PAGEFILE Serial Number B45A9136 TYPE Fixed Disk       SIZE 100.0 GB  SPACE USED 96.8 GB  SPACE AVAILABLE 3.2 GB   PERCENT USED 97 %  PERCENT AVAILABLE 3 %

Could use a little help.  Thanks all!

jmyers · Answer

I will try that.  We recently had a SQL server crash (with no backup since 2019...smhv) Once I get Orion back to full operation, I will try this.  Thank you for the input.

ioan_bucsa · Answer

Have you tried adding AND DisplayName NOT LIKE '*<Filter_Criteria>*' at the end of your SWQL query?