In Exchange 2007 We have may have lots of DBs which we land up in creating multiple mount points instead of Drives for each Logs and Database. Below script helps to pull out the size and free size of all the mount point of the database . Change the servername and for loop with the number of Database you have.
$K = gwmi win32_volume -computername “Servername” |where-object {$_.name -like “C:\Mountpoints\DB*”}|select name,capacity,freespace
for ($i=0; $i -le 22; $i++)
{
$name = $K[$i].name
$Capacity = [math]::truncate($K[$i].capacity/1gb)
$freespace = [math]::truncate($K[$i].freespace/1gb)
$L = $name + ” ” + $Capacity + ” ” + $freespace
write-output $L
}