XML FeedsIn a previous post I showed how to get remote disk information with PowerShell. The script works nice until you execute it on a server with Mount Points. When executing the following script on a server with Mount Points:
- Get-WmiObject win32_logicaldisk -computer <computername> |
- select-object DeviceID, VolumeName, @{Name="Size";Expression={$_.Size/1GB}},@{Name="FreeSpace";Expression={$_.FreeSpace/1GB}},
- @{Name="PCTFreeSpace";Expression={
- $_.FreeSpace/$_.Size*100}}|Sort-Object -descending PCTfreespace|format-table
I get the following result:
Knowing the sizes of my databases, I knew the numbers were wrong. So I opened a RDP session to the server and found this picture in Disk Management:
At that moment I realized I wasn't getting the information from the Mount Points, just from the Disks that had a drive letter assigned to them.
So let's find out how we can get that information with Windows PowerShell. I still need the wmiobject but instead of the win32_logicaldisk I'm going to use the win32_volume. I also replace the DeviceID and VolumeName objects with Name and Label:
- get-wmiobject win32_volume -computer <computername\|
- select name, label, driveletter
The result looks like this:
As you can see, the drive letter properties are empty for my Mount Points and in the name column I can find the file and folder where they are mounted.
So let's find the space, free space and percentage free space of the volumes. I can use the calculations from my previous script only Size needs to be replaced with Capacity:
- get-wmiobject win32_volume -computer <computername\|
- select name, label, @{Name="Capacity (GB)";Expression={$_.Capacity/1GB}},@{Name="FreeSpace (GB)";Expression={$_.FreeSpace/1GB}},
- @{Name="FreeSpace (PCT)";Expression={$_.FreeSpace/$_.Capacity*100}} |
- format-table
The result now shows the drives and Mount Points with all the requested information:
To be able to reuse the script I do what I did in the other two PowerShell post:
- param(
- [string] $compname = $(Throw "Provide a Server name as first parameter")
- )
- Get-WmiObject win32_volume -computer $compname |
- select name, label, @{Name="Capacity (GB)";Expression={$_.Capacity/1GB}},
- @{Name="FreeSpace (GB)";Expression={$_.FreeSpace/1GB}},
- @{Name="FreeSpace (PCT)";Expression={$_.FreeSpace/$_.Capacity*100}} |
- format-table
End that's it, the next request for free disk space is a matter of seconds again.
Axel started his IT career more than a decade ago. After a few months he was the accidental DBA for the SQL Server 6.5 running the Service Desk application. It didn't took long or Axel started to focus on SQL Server and after another year he became the full-time DBA in a large Belgian datacenter managing the SQL Servers for the hosted customers.It's more than five years now since he switched to consulting and teaching SQL Server.
Axel is a Microsoft Certified DBA and Trainer.
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.