Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Filtering Volume Resource to Only Show C Drive

I'm trying to use the filter on a Volume resource to only show C Drives. I'm using the correct volume property but it doesn't seem to work. I'm getting incorrect SQL errors.

This is my string:

VolumeType = 'Fixed Disk' AND VolumePercentUsed >=85 AND Caption like 'C*'

According to the examples it should be working, but I get this:

Any ideas?

Find more posts tagged with

Accepted answers

jeilers

I think you want to change the filter to

VolumeType = 'Fixed Disk' AND VolumePercentUsed >=85 AND Volumes.Caption like 'C%'

All comments

jeilers

I think you want to change the filter to

VolumeType = 'Fixed Disk' AND VolumePercentUsed >=85 AND Volumes.Caption like 'C%'

mesverrum

I want to say that this resource is doing a join between nodes and volumes tables, in which case caption would be a column in both cases and you need to specify which caption you need, so I'd try volume.caption like 'c%', if that doesn't fly there is another field in that list that contains the drive letters by themselves, except I can't remember the name of the field off the top of my head.

Another possibility is that a bunch of resources got weird about their SQL filters in the latest release so there could be a bug. My lab is under the knife getting some work done today so I can't test it right now to confirm my ideas one way or the other, but try those out and let us know how it goes.

mesverrum

I borrows a friend's environment to test, it looks like your syntax works fine there. I copied and pasted exactly what you have here for your string into the Top xx volumes by disk used resource and got the correct results. This was in an NPM 12.3/sam 6.6 environment with all the latest hotfixes.

bharris1

Thanks jeilers that worked on my NPM 12.1 instance!