Filter SQL Servers based on volume letter

Most of our SQL Servers are labeled SQL so I can filter those with the following syntax:

Nodes.Caption like '*SQL*'

If I want to filter based on the drive letter, when creating a drive capacity report which node properties would I use? I've tried filtering on Nodes.DetailsURL not like '*C:\*', but that doesn't seem to exclude any of the C: volumes we have on the SQL machines (we normally keep the data files on the drives).

Any further documentation on Properties that can be used for filtering Nodes would be very helpful!

Thanks,

Mike

Find more posts tagged with

volume capacity forecast

volume

Accepted answers

All comments

blkchampion

You would have to filter on the Volumes.Caption field and you would have to do a join between the Nodes table and the volumes table. Something like this.

Select Volumes.Caption, Nodes.Caption

From Nodes

Join Volumes on Nodes.NodeID = Volumes.NodeID

where Nodes.Caption like '%SQL%' and Volumes.Caption not Like '%C:\*%'

Hope this helps.

mwerts

Actually, I am trying to create a report which limits me to only a filter.

Is there any way to further qualify this using a SQL Select string like the example you provided above?

Thanks Again,

Mike

blkchampion

Try this in the filter

Nodes.Caption like '%SQL%' and Volumes.Caption not Like '%C:\*%'

it should work.

FormerMember

It is a shame you can't add forecasting functionality into a standard disk report, that way you would have the flexibility to display the metrics you want plus add a forecast section into the report too.

Something for solarwinds to think about...

I'm doing some forecasting in Excel at the moment because of the limitations of the capacity reports for some of our more advanced reports that have been demanded from the NHS.

cuppadan

Actually the syntax didn't work for me. I had to remove the * from the '%c:\*%' and use '%c:\%'. This is basically using two wildcards when you only need one.

Then it worked. Great for other uses too.