1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

$VMs = Get-VM
foreach ($VM in $VMs)
{
	$Disks = Get-VM $VM | Get-SCVirtualHardDisk
	foreach ($Disk in $Disks)
	{
		if ($Disk.VHDType -ne "FixedSize")
		{
			$DiskLocation = $Disk.Location
			$CSVVolume = ($Disk.Location.Split("\"))[2]
			$DiskName = ($Disk.Location.Split("\"))[-1]
			$DiskSize = ([math]::round(($Disk.Size/1GB), 0))
			$DiskMSize = ([math]::round(($Disk.MaximumSize/1GB), 0))
			$DiskHost = $Disk.VMHost
			$CSVFreeSpace = ([math]::round(((Get-SCStorageVolume | where VMHost -eq $DiskHost | Where Name -like "*$CSVVolume*").FreeSpace/1GB), 0))
			$CSVCapacity = ([math]::round(((Get-SCStorageVolume | where VMHost -eq $DiskHost | Where Name -like "*$CSVVolume*").Capacity/1GB), 0))
			$Value = $VM.Name + ";" + $DiskName + ";" + $CSVVolume + ";" + $CSVFreeSpace + ";" + $CSVCapacity + ";" + $DiskMSize + ";" + $DiskSize + ";" + $DiskHost
			Add-Content -Path DiskUsage.txt -Value $Value
		}
	}
}

$VMs = Get-VM foreach ($VM in $VMs) { $Disks = Get-VM $VM | Get-SCVirtualHardDisk foreach ($Disk in $Disks) { if ($Disk.VHDType -ne "FixedSize") { $DiskLocation = $Disk.Location $CSVVolume = ($Disk.Location.Split("\"))[2] $DiskName = ($Disk.Location.Split("\"))[-1] $DiskSize = ([math]::round(($Disk.Size/1GB), 0)) $DiskMSize = ([math]::round(($Disk.MaximumSize/1GB), 0)) $DiskHost = $Disk.VMHost $CSVFreeSpace = ([math]::round(((Get-SCStorageVolume | where VMHost -eq $DiskHost | Where Name -like "*$CSVVolume*").FreeSpace/1GB), 0)) $CSVCapacity = ([math]::round(((Get-SCStorageVolume | where VMHost -eq $DiskHost | Where Name -like "*$CSVVolume*").Capacity/1GB), 0)) $Value = $VM.Name + ";" + $DiskName + ";" + $CSVVolume + ";" + $CSVFreeSpace + ";" + $CSVCapacity + ";" + $DiskMSize + ";" + $DiskSize + ";" + $DiskHost Add-Content -Path DiskUsage.txt -Value $Value } } }