Solved

Windows Server 2008 R2 Data volume information

Posted on 2013-10-28
6
332 Views
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?
0
Comment
Question by:RayManAaa
  • 3
  • 2
6 Comments
 
LVL 16

Expert Comment

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

http://www.whatsupgold.com/

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

Accepted Solution

by:
Brian Pringle earned 500 total points
ID: 39605678
0
 
LVL 16

Expert Comment

by:Brian Pringle
ID: 39605713
I also just found this when looking at another question...

http://www.ca.com/us/lpg/nimsoft-monitor-snap/register.aspx
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:RayManAaa
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
0
 
LVL 80

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
    c:\scripts\drivesizes.csv

Open in new window

0
 

Author Comment

by:RayManAaa
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
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
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…

830 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