Solved

Windows Server 2008 R2 Data volume information

Posted on 2013-10-28
6
326 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
Comment Utility
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
Comment Utility
0
 
LVL 16

Expert Comment

by:Brian Pringle
Comment Utility
I also just found this when looking at another question...

http://www.ca.com/us/lpg/nimsoft-monitor-snap/register.aspx
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:RayManAaa
Comment Utility
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 78

Expert Comment

by:David Johnson, CD, MVP
Comment Utility
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
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now