looking for a script

[Mallik7]

hello, looking for a powercli script to help to get the list of VMs from a vCenter along with cluster name and vCenter.

format should be like this -

vCenter name - VM name - Cluster name

this output should be saved in a .csv format

TIA

[LucD · Accepted solution]

Get-Cluster -PipelineVariable cluster |

Get-VM | ForEach-Object -Process {

    New-Object -TypeName PSObject -Property @{

        vCenter = ([System.Uri]$_.ExtensionData.Client.ServiceUrl).Host

        Cluster = $cluster.Name

        VM = $_.Name

    }

} | Select vCenter, VM, Cluster |

Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture

[Mallik7]

thanks, but, it is not capturing the vCenter name. can you please have look

[LucD]

Corrected

[Mallik7]

its working as expected. thank you LucD