Earlier I have written this article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server. I recently received excellent comment by MVP Ravikanth. He demonstrated that how the same can be done using Powershell. It is very sweet and quick solution.
Here is the powershell script. Run the same in your powershell windows.
Get-WmiObject -Class Win32_LogicalDisk | Select -Property DeviceID, @{Name=’FreeSpaceMB’;Expression={$_.FreeSpace/1MB} } | Format-Table -AutoSizeWell, I ran this script in my powershell window, it gave me following result – very accurately and easily.
Get-WmiObject -Class Win32_LogicalDisk | Select -Property DeviceID, @{Name=’FreeSpaceMB’;Expression={$_.FreeSpace/1MB} } | Format-Table -AutoSize
Thanks Ravikanth one more time for excellent tip.
Reference: Pinal Dave (https://blog.sqlauthority.com)
11 Comments. Leave new
Well sometimes you don’t have the access rights on some machine, while you have the rights to use xp_fixeddrives. I need both methods to get all the information I need.
The source code for the PowerShell command is cut-off when viewed with IE9, so for those who cannot see the full line here it is:
Get-WmiObject -Class Win32_LogicalDisk | Select -Property DeviceID, @{Name=’FreeSpaceMB’;Expression={$_.FreeSpace/1MB} } | Format-Table -AutoSize
Good one, this is my first reply to sqlauthority.com. Pinal, it there any way to get total drive space as well?
Can you also help the script to view the list of files which occupies more space in disk .
a good one! simple and easy!
Here is a better script, which also displays mountpoints and status information:
how do you add the computer name on the result
This is exactly what I needed, but is there a way to display raid type i.e. Raid 0, etc?
Is there a way to get Raid level information?
Can i get the whole disk space with mount points using power shell and as well as i want all the servernames with physical names for all the servers.
gwmi Win32_LogicalDisk -Filter “Drivetype=3” |select Computername, Name, FreeSpace,BlockSize,Size | % {$_.Computername=($env:COMPUTERNAME);$_.BlockSize=(($_.FreeSpace)/($_.Size))*100;$_.FreeSpace=($_.FreeSpace/1GB);$_.Size=($_.Size/1GB);$_} | Format-Table Computername, Name, @{n=’Capacity_Gb’;e={‘{0:N3}’ -f $_.Size}}, @{n=’FreeGb’;e={‘{0:N2}’-f $_.FreeSpace}}, @{n=’Free_%’;e={‘{0:N2}’-f $_.BlockSize}} -AutoSize
Computername Name Capacity_Gb FreeGb Free_%
———— —- ———– —— ——
MyLaptop C: 465.760 397.52 85.35