Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


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

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
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…

578 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