cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

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

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:

 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!

 

0 Kudos
1 Reply
Level 12

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

0 Kudos