Go Premium for a chance to win a PS4. Enter to Win


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
  • 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...

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.


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 84

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
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…

916 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