VM disk info powershell script

VM disk info powershell script

$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) {

  ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) { 

    ForEach ($VM in ($Cluster | Get-VM | Sort-Object -Property Name)) {

      ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name)) {

        "" | Select-Object -Property @{N="VM";E={$VM.Name}},

          @{N="Datacenter";E={$Datacenter.name}},

          @{N="Cluster";E={$Cluster.Name}},

          @{N="Hard Disk";E={$HardDisk.Name}},

          @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},

          @{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}},

          @{N="VMDKpath";E={$HardDisk.FileName}},

  @{N="Storage Format";E={$HardDisk.StorageFormat}},

          @{N="VMDK Size";E={($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}}

      }

    }

  }

}

$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "VmInfo.csv"

#############################

# Get data about vmdk and format

# 

# Niklas Åkerlund / RTS

$VMs = Get-VM *

$Data = @()

 foreach ($VM in $VMs){

$VMDKs = $VM | get-HardDisk

foreach ($VMDK in $VMDKs) {

if ($VMDK -ne $null){

$CapacityGB = $VMDK.CapacityKB/1024/1024

$CapacityGB = [int]$CapacityGB

$into = New-Object PSObject

Add-Member -InputObject $into -MemberType NoteProperty -Name VMname $VM.Name

Add-Member -InputObject $into -MemberType NoteProperty -Name Datastore $VMDK.FileName.Split(']')[0].TrimStart('[')

Add-Member -InputObject $into -MemberType NoteProperty -Name VMDK $VMDK.FileName.Split(']')[1].TrimStart('[')

Add-Member -InputObject $into -MemberType NoteProperty -Name StorageFormat $VMDK.StorageFormat

Add-Member -InputObject $into -MemberType NoteProperty -Name CapacityGB $CapacityGB

$Data += $into

}

}

}

$Data | Sort-Object VMname,Datastore,VMDK | Export-Csv -Path C:\iso\VM-VMDKs.csv -NoTypeInformation