Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Windows Server 2008 R2 Data volume information

Posted on 2013-10-28
Medium Priority
Last Modified: 2013-11-12
I have a general question, in regards to checking the sizes of the drive volume (used space and free space) for 32 SQL servers.  At the present time I have to map or RDP to each server and I am looking for a way to streamline this process.  Is there a free tool or powershell example that I can use to scan all the drive volumes to provide me the used space and free space of each drive volume?
Question by:RayManAaa
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 16

Expert Comment

by:Brian Pringle
ID: 39605675
It is not free, but we used to use this program.

It allowed us to monitor network connections, server uptime, updates, inventory of applications and drives, and much more.
LVL 16

Accepted Solution

Brian Pringle earned 2000 total points
ID: 39605678
LVL 16

Expert Comment

by:Brian Pringle
ID: 39605713
I also just found this when looking at another question...
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.


Author Comment

ID: 39606552
I like the Powershell option and I already have it working to display the drive information. However when I tried to export the information into a CSV file it is creating the file but it is not exporting the data into the file.

This is what I have so far any ideas?

 Get-WMIObject Win32_LogicalDisk -filter ‘DriveType=3’ -computer (Get-Content c:\scripts\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name=’Size(GB)’;Expression={‘{0:N1}’ -f($_.size/1gb)}},@{Name=’Free Space(GB)’;Expression={‘{0:N1}’ -f($_.freespace/1gb)}},@{Name=’Free Space(%)’;Expression={‘{0:N1}’ -f(100 * $_.freespace/1gb) / ($_.size/1gb)}} | Out-GridView -Title ‘Drive Space’ | out-file –filepath c:\scripts\drivesizes.csv -append
LVL 83

Expert Comment

by:David Johnson, CD, MVP
ID: 39606845
Get-WMIObject Win32_LogicalDisk -filter ‘DriveType=3’ -computer (Get-Content c:\scripts\computers.txt) | 
    Select SystemName,DeviceID,VolumeName,@{Name=’Size(GB)’;Expression={‘{0:N1}’ -f($_.size/1gb)}},@{Name=’Free Space(GB)’;Expression={‘{0:N1}’ -f($_.freespace/1gb)}},@{Name=’Free Space(%)’;Expression={‘{0:N1}’ -f(100 * $_.freespace/1gb) / ($_.size/1gb)}} | 
    Export-Csv -Append -NoTypeInformation c:\scripts\drivesizes.csv

Open in new window


Author Comment

ID: 39617177
I am sorry that I am replying so late, I got engaged in other fires that needed my attention.

I tried to run the last script as posted but it did not work, I am getting the following error message.  

Export-Csv : A parameter cannot be found that matches parameter name 'Append'.
At line:3 char:23
+     Export-Csv -Append <<<<  -NoTypeInformation c:\scripts\drivesizes.csv
    + CategoryInfo          : InvalidArgument: (:) [Export-Csv], ParameterBindingException
    + FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.PowerShell.Commands.ExportCsvCommand

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question