I'm trying to write a filter to filter out servers and drives from the "high volumes" resource. I'm trying to only show drives that are fixed and over 95% utilized but then also have an additional filter that of all the servers that meet the first set of criteria, only show the C drive on servers that have the string CAW in the caption. I tried this, but it doesn't seem to be working.
VolumePercentUsed > 95 AND VolumeType like 'Fixed Disk' AND (Nodes.Caption like '%CAW%' AND Volumes.Caption like 'C%')
Thanks!