You can do something like this.

But be aware that this will not report VMHost, Clusters and Datacenters that do not have any VM in them.

1. Which VM information do you want to include in the report, beside the VM name ?

2. A ForEach loop doesn't place anything in the pipeline, but you can fix that by using a call (&) operator.

Like this

Try this variation

Hi LucD,

In addition to your script, I'm trying to incorporate the following properties:

• VM O/S
• VM vCPU
• VM RAM (GB)
• VM Power State
• VM Folder

Bonus (not a must!!)

• ESXi Model
• VM Guest Count on each Physical Host

As always, you help and support is kindly appreciated.

That would mean the report layout has to change.
Instead of 1 ESXi per line, you will then have 1 VM per line.

But that would also mean you will have a lot of repetitive info (for the ESXi node) on each VM line.

Or do you have another layout in mind?
Perhaps separate CSV or worksheets?

The requirement is to list VMs per Datacenter, Cluster, ESXi host and then provide the following:

VM O/S

VM vCPU

VM RAM (GB)

VM Power State

VM Folder

Having knocked up the below script, the cluster property does not appear in final output:

Get-Cluster | Get-VM | Select-Object Name, PowerState, NumCpu, MemoryGB, Guest, Folder |

Export-Csv -Path "c:\Scripts\VM_Config-1.csv" -NoTypeInformation -UseCulture

----------------------------------------------------------------------------------------

PS.

I'm unable to tie in cluster with Datacenter property using the above example?

The pipeline variable helps in that case.

Cheers for that LucD,

For some strange reason, the script only outputted info against one DC in one of the two VCs cf which numerous DCs, Clusters, VMs are held.

add-pssnapin VMware.VimAutomation.Core

$Credential = Get-Credential

Connect-VIServer -Server VC1,VC2 -Credential $Credential

Get-Datacenter -PipelineVariable dc |

Get-Cluster -PipelineVariable cl -ErrorAction SilentlyContinue |

Get-VM -ErrorAction SilentlyContinue |

Select-Object @{N='Datacenter';E={$dc.Name}},

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

    Name, PowerState, NumCpu, MemoryGB, Guest, Folder |

Export-Csv -Path "c:\Scripts\Cluster_VMs.csv" -NoTypeInformation -UseCulture

I suspect that would require another forach loop (on the outside of the current ones), that loops through all the vCenters.

Are you connected to all vCenters (check $global:defaultviservers), or are you running in linked-mode?

DefaultVIServerMode is set to Multiple. 

Can you kindly do the honours my friend?  ;-)