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

SQL Help for top 10 volume custom view

Hey peeps,

I was wondering if someone could help me with this. I have on my network home page in solarwinds showing the Top 10 Volumes by Disk Space Used. I just want it to show Hard drive (c, e,f ,g etc) not system ram or physical memory or real/virtual memory..

any clues?

1.jpg

Find more posts tagged with

Accepted answers

All comments

kbenton

This did it for me:

Volumes.Caption not like '%Memory'

grantsewell

Your other option is to use:

VolumeType="Fixed Disk"

I've used this similarly in an advanced alert. Should work fine here as well.

Solorwindshopper

yah Volumes.Caption not like '%Memory' worked... using VolumeType="Fixed Disk" invaild column fixed disk.

grantsewell

yah Volumes.Caption not like '%Memory' worked... using VolumeType="Fixed Disk" invaild column fixed disk.

My bad - that's what I get for posting before verifying.

The correct syntax should be:

VolumeType='Fixed Disk'

The problem was in the double quotations - should be single. That will work properly. It's probably best to use the filter this way, as it should also ignore external floppy and optical drives.

kulastone

Thanks guys!! this really fixed everything!!

Where would i be without fellow helpful "solarwinders"