VM info with folder

[mburutzis]

Hi all,

I am looking for a way to export to csv/xls all VM info:

• Datacenter
• Cluster
• VM name
• VM folder
• VM disk size (provisionned) per disk
• VM disk datastore location
• If any RDM and size

Is this possible?

[LucD]

Try it like this

foreach($vm in Get-VM){
    $vm.HardDisks | Select @{N="VM";E={$vm.Name}},
    @{N="Folder";E={$vm.Folder.Name}},
    @{N="Cluster";E={(Get-Cluster -VM $vm).Name}},
    @{N="Datacenter";E={(Get-Datacenter -VM $vm).Name}},
    @{N="Disk";E={$_.Name}},
    @{N="Disk datastore";E={$_.Filename.Split(']')[0].TrimStart('[')}},
    @{N="Disk capacity";E={$_.CapacityKB}},
    @{N="Disk type";E={$_.DiskType}}
}

If you have a larger environment, then it will be better to go for a Get-View solution.

[mburutzis]

well, I have over 800 vms.  I would need to export this into a csv.  If I add export-csv at the end, will it work?

[CRad14]

Ugh LucD, you are too good.

I like how you did the .harddisks first and then used it in the pipeline later on....Super Slick

[LucD · Accepted solution]

Since the Select-Object is in a Foreach loop, you'll have to do this a bit different.

Store the results in a variable and then pipe that variable to the CSV file.

$report = foreach($vm in Get-VM){
    $vm.HardDisks | Select @{N="VM";E={$vm.Name}},
    @{N="Folder";E={$vm.Folder.Name}},
    @{N="Cluster";E={(Get-Cluster -VM $vm).Name}},
    @{N="Datacenter";E={(Get-Datacenter -VM $vm).Name}},
    @{N="Disk";E={$_.Name}},
    @{N="Disk datastore";E={$_.Filename.Split(']')[0].TrimStart('[')}},
    @{N="Disk capacity";E={$_.CapacityKB}},
    @{N="Disk type";E={$_.DiskType}}
}

$report | Export-Csv "C:\report.csv" -NoTypeInformation -UseCulture 

[mburutzis]

wow, this is taking some time... still runing.  I started it about an hour and a half ago.  Will let you know if its working.

[mburutzis]

Excellent. This worked great.  The only issue I had was the time it took and does not give the full path for the VM Folder.

Thanks LucD. You rock!

[LucD]

Ok, this is the faster version based on the Get-View cmdlet.

The code looks a bit more complex but it should be faster.

And it should give the full folder path

Update: must be getting late , this should be faster

foreach($vm in (Get-View -ViewType VirtualMachine -Property Name,Parent,ResourcePool,Config.Hardware.Device)){
    $t = Get-View $vm.Parent -Property Name,Parent
    $path = $t.Name
    while($t.GetType().Name -eq "Folder"){
        $t = Get-View $t.Parent
        if($t.Name -ne "vm"){
            $path = $t.Name + "/" + $path
        }
    }
    $t = Get-View $vm.ResourcePool -Property Name,Parent
    while($t.getType().Name -ne "ClusterComputeResource"){
        $t = Get-View $t.Parent -Property Name,Parent
    }
    $cluster = $t.Name
    while($t.getType().Name -ne "Datacenter"){
        $t = Get-View $t.Parent -Property Name,Parent
    }
    $datacenter = $t.Name
    
    $vm.Config.Hardware.Device | where {$_.GetType().Name -eq "VirtualDisk"} | 
    Select @{N="VM";E={$vm.Name}},
    @{N="Folder";E={$path}},
    @{N="Cluster";E={$cluster}},
    @{N="Datacenter";E={$datacenter}},
    @{N="Disk";E={$_.DeviceInfo.Label}},
    @{N="Disk datastore";E={$_.Backing.Filename.Split(']')[0].TrimStart('[')}},
    @{N="Disk capacity";E={$_.CapacityInKB}},
    @{N="Disk type";E={
            if($_.Backing.GetType().Name -match "flat"){
                "Flat"            }
            else{
                $_.Backing.CompatibilityMode
            }}}
}

[mburutzis]

Thanks LucD.  I keep getting the following error:

Get-View : Cannot validate argument on parameter 'VIObject'. The argument is null or empty. Supply an argument that is not null or empty and then try the command again.

At C:\Scripts\vm-disk-info2.ps1:12 char:22

+         $t = Get-View <<<<  $t.Parent -Property Name,Parent

    + CategoryInfo          : InvalidData: (:) [Get-View], ParameterBindingValidationException

    + FullyQualifiedErrorId : ParameterArgumentValidationError,VMware.VimAutomation.ViCore.Cmdlets.Commands.DotNetInterop.GetVIView

Also, How do I get this into a csv?

[LucD]

The same as the previous one

$report = foreach($vm in (Get-View -ViewType VirtualMachine -Property Name,Parent,ResourcePool,Config.Hardware.Device)){
...

$report | Export-Csv "C:\report.csv" -NoTypeInformation -UseCulture 

[LucD]

Do you perhaps have VMs that are not in a cluster but directly created under an ESX(i) host ?

[mburutzis]

Yes, there is some.  Then this would be the error and should be ignored?

[LucD]

No, try this updated version

foreach($vm in (Get-View -ViewType VirtualMachine -Property Name,Parent,ResourcePool,Config.Hardware.Device)){
    $t = Get-View $vm.Parent -Property Name,Parent
    $path = $t.Name
    while($t.GetType().Name -eq "Folder"){
        $t = Get-View $t.Parent
        if($t.Name -ne "vm"){
            $path = $t.Name + "/" + $path
        }
    }
    $t = Get-View $vm.ResourcePool -Property Name,Parent
    while($t.getType().Name -eq "ResourcePool"){
        $t = Get-View $t.Parent -Property Name,Parent
    }
        if($t.GetType().Name -eq "ClusterComputeResource"){
        $cluster = $t.Name
        }
        else{
            $cluster = "na"
        }
    while($t.getType().Name -ne "Datacenter"){
        $t = Get-View $t.Parent -Property Name,Parent
    }
    $datacenter = $t.Name
    
    $vm.Config.Hardware.Device | where {$_.GetType().Name -eq "VirtualDisk"} | 
    Select @{N="VM";E={$vm.Name}},
    @{N="Folder";E={$path}},
    @{N="Cluster";E={$cluster}},
    @{N="Datacenter";E={$datacenter}},
    @{N="Disk";E={$_.DeviceInfo.Label}},
    @{N="Disk datastore";E={$_.Backing.Filename.Split(']')[0].TrimStart('[')}},
    @{N="Disk capacity";E={$_.CapacityInKB}},
    @{N="Disk type";E={
            if($_.Backing.GetType().Name -match "flat"){
                "Flat"
            }
            else{
                $_.Backing.CompatibilityMode
            }}}
}

The output will say "na" when the VM doesn't belong to a cluster

[mburutzis]

Excellent, this works like a charm.

Thanks again LucD

[mburutzis]

Is it possible to get the following info:

datastore, VM name, Host, total provisioned space, folder name

[RvdNieuwendijk]

You can get the requested info with:

Get-VM | Select-Object -Property @{N="Datastore";E={[string]::Join(",",($_ | Get-Datastore))}},@{N="VM";E={$_.Name}},
ProvisionedSpaceGB,VMHost,@{N="Folder";E={$_.Folder.Name}}

Regards, Robert

[LucD]

Did you want that included in the script above ?

[mburutzis]

Instead of the individual disks, yes... please

[mburutzis]

Exactly what I was looking for... Thanks again RvdNieuwendijk

[mburutzis]

is there a way to use this script with an import of csv that has a list of servers in it?