param($ServerName = "localhost") $ServerName cd SQLSERVER:\SQL\$ServerName\DEFAULT\Databases; $a = dir; $Size = @{Label="Size(MB)"; expression={"{0:N2}" -f ($_.Size)}}; $DataSpaceUsage = @{Label="DataSpaceUsage(MB)"; expression={"{0:N2}" -f ($_.DataSpaceUsage/1024)}}; $IndexSpaceUsage = @{Label="IndexSpaceUsage(MB)"; expression={"{0:N2}" -f ($_.IndexSpaceUsage/1024)}}; $TotalSpaceUsage = @{Label="TotalSpaceUsage(MB)"; expression={"{0:N0}" -f (($_.DataSpaceUsage + $_.IndexSpaceUsage)/1024)}}; $SpaceAvailable = @{Label="SpaceAvailable(MB)"; expression={"{0:N2}" -f ($_.SpaceAvailable/1024)}}; $a | FT Name, $Size, $DataSpaceUsage, $IndexSpaceUsage, $TotalSpaceUsage, $SpaceAvailable -auto #### Now get the total and put it into diff measures. $Total = ($a | measure -property size -sum) # $a | %{$Total += $_.size} $TotalInMB = @{Label="Total(MB)"; expression={"{0:N2}" -f ($_.sum)}}; $TotalInGB = @{Label="Total(GB)"; expression={"{0:N2}" -f ($_.sum/1024)}}; $TotalInTB = @{Label="Total(GB)"; expression={"{0:N2}" -f ($_.sum/1024/1024)}}; $Total | FT $TotalInMB, $TotalInGB, $TotalInTB CD C:\ DIR | %{ $Total += $_.Size }; $Total