Need help with powercli script to get cluster to datacenter to vcenter mapping

[VishnuN87]

Need help with powercli script to get cluster to datacenter to vcenter mapping. Have tried with get-cluster or the get-datacenter but not getting the desired output

vcenter | datacenter | cluster

[LucD]

Did you try like this?

Get-Cluster -PipelineVariable cluster | Get-Datacenter |
Select-Object @{N = 'vCenter'; E = { ([uri]$cluster.ExtensionData.Client.ServiceUrl).Host }},
  @{n='Datacenter';E={$_.Name}},
  @{N='Cluster';E={$cluster.Name}}

[VishnuN87]

Thanks  Lucd , that works like a charm. But i Could see that for some vcenters it has not collected all the clusters .

Do we have a script to run RVTools for multiple vcenters  and combine the output into a single excel file ?

[LucD]

To run that against multiple vCenters have a look at Solved: Re: Invoke multiple vcenters from rvtoolsbatch - VMware Technology Network VMTN

To merge all resulting XLSX files into 1 XLSX file, see powershell - How to merge multiple excel files and update the merged file's worksheet names as excel...