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

Capacity report. How to tweak

I want to fun a filter on the "canned" capacity report but am running into an issue.

I want to omit certain volume drive letters since they are fixed

what I need to know is what table is detail referencing ? If I know that then I can add all the drive letter exclusions I need.

Thanks

Jeff

Find more posts tagged with

Accepted answers

All comments

taylor.crowley

You will be calling the ForecastCapacity table for this and you can use the DisplayName column. Below is an example of omitting any Windows volumes starting with C:

Nodes.Vendor = 'Windows' AND ForecastCapacity.DisplayName NOT LIKE 'C:%'

You can add additional drive letters on if you want to omit more. For example the below will omit drives starting with C and

Nodes.Vendor = 'Windows' AND ForecastCapacity.DisplayName NOT LIKE 'C%' AND ForecastCapacity.DisplayName NOT LIKE 'D%'

NOTE: There may be a more efficient way to do that filter for multiple volumes using the NOT IN function