Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Bradley Schacht

Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer and tech edited the SQL 2011 Bible. His experience on the Microsoft BI platform includes DTS, SSIS, SSRS, SSAS and migrations and conversions. He has helped numerous companies in successfully developing and implementing new business intelligence solutions into their organizations. Bradley also participates as a speaker in community events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).

Check Mount Points and Disk Free Space with PowerShell

Those who know me will know that this post is a little out of the ordinary… I am posting about PowerShell. I have done one previously about Backing up and restoring site collection in SharePoint, so believe me I will admit that it has its place.  Well I was onsite with a client today and found another use for PowerShell: checking the size of and free space on mount points on an HP appliance.  This method will work with any machine, but this specifically happen to be on a server using mount points.  The script isn’t exactly friendly to remember, but that’s what you have that little bookmark button at the top of the browser for.  :)

Mount points are specialized NTFS file system objects used to provide entry into another volume.  In this particular case the fast track hardware from HP used mount points to connect to the storage for a combined total of over 24 TB.  I didn’t want to leave that amount of storage or the 200GB of memory behind, but it had to happen.   Anyway, you can’t just right click on the mount point (which just shows up as a shortcut on the file system) and go to properties to see the amount of storage available.  Nor can you open My Computer and right click and do that for the C:\ drive because it will show you just the C drive, not all the mount points.  The following PowerShell script to the rescue.  It will display the storage total size and amount of free space in bytes, so you have to do a little conversion to get it into a useful number for you.

1
gwmi win32_volume|where-object {$_.filesystem -match “ntfs”}|ft name,capacity,freespace

The output will look something like this:

Comments

Posted by Jeffrey Yao on 12 August 2011

Another way I'd prefer is the following (using -filter):

gwmi win32_volume -filter "FileSystem='NTFS'" | select name, capacity, freespace

Leave a Comment

Please register or log in to leave a comment.