SQLServer MountPoint Disk Space

Get-WmiObject -class "win32_volume" -namespace "root\cimv2" -computername ServerName |

Where-Object {$_.name -notmatch "\\\\" -and $_.DriveType -eq "3"} |

Select-Object Name, Label, @{name="CapacityGB";Expression={"{0:N0}"  -f ($_.capacity / 1gb)}},

@{name="UsedGB";Expression={"{0:N0}"  -f ($($_.capacity-$_.freespace) / 1gb)}},

@{name="FreeGB";Expression={"{0:N0}"  -f ($_.freespace / 1gb)}},

@{name="FreePC";Expression={"{0:N0}"  -f ($_.freespace / $_.capacity * 100)}} |

Sort-Object SystemName,Name | ft -AutoSize

Get-WmiObject -class "win32_volume" -namespace "root\cimv2" -computername ServerName |

Where-Object {$_.name -notmatch "\\\\" -and $_.DriveType -eq "3"} |

Select-Object Name, Label, @{name="CapacityGB";Expression={"{0:N0}"  -f ($_.capacity / 1gb)}},

@{name="UsedGB";Expression={"{0:N0}"  -f ($($_.capacity-$_.freespace) / 1gb)}},

@{name="FreeGB";Expression={"{0:N0}"  -f ($_.freespace / 1gb)}},

@{name="FreePC";Expression={"{0:N0}"  -f ($_.freespace / $_.capacity * 100)}} |

Sort-Object SystemName,Name

| Out-GridView -Title "Drive Space"

 

will show as