-
1. Re: Query Multiple vCenters for (vCenter name, Datacenter name, Cluster Name, No. of Cluster Hosts, No. of VMs)
The table column headers are:
| vCenter Name | Datacenter Name | Cluster Name | No. of Cluster Hosts | No. of Cluster VMs |
-
2. Re: Query Multiple vCenters for (vCenter name, Datacenter name, Cluster Name, No. of Cluster Hosts, No. of VMs)
Try like this
Foreach($vc in $global:DefaultVIServers){
foreach($dc in Get-Datacenter -Server $vc){
Get-Cluster -Location $dc -Server $vc |
Select @{N='VC';E={$vc.Name}},
@{N='Datacenter';E={$dc.Name}},
@{N='Cluster';E={$_.Name}},
@{N='#ESXi';E={$_.ExtensionData.Host.Count}},
@{N='#VM';E={(Get-View -Id $_.ExtensionData.Host).Vm.Count}}
}
}
-
3. Re: Query Multiple vCenters for (vCenter name, Datacenter name, Cluster Name, No. of Cluster Hosts, No. of VMs)
Thanks Luc, it works a treat!
I added a few mods (that Luc has previously shown me in previous threads) that perhaps others may be interested in:
- Read in a text file list of vCenters
- Output table to a CSV file
Connect-viserver -Server (Get-Content C:\Scripts\vCList_test.txt) > $null
$report = Foreach($vc in $global:DefaultVIServers){
foreach($dc in Get-Datacenter -Server $vc){
Get-Cluster -Location $dc -Server $vc |
Select @{N='VC';E={$vc.Name}},
@{N='Datacenter';E={$dc.Name}},
@{N='Cluster';E={$_.Name}},
@{N='#ESXi';E={$_.ExtensionData.Host.Count}},
@{N='#VM';E={(Get-View -Id $_.ExtensionData.Host).Vm.Count}}
}
}
$report | Export-Csv C:\Scripts\vClusterListInfo.csv
-
4. Re: Query Multiple vCenters for (vCenter name, Datacenter name, Cluster Name, No. of Cluster Hosts, No. of VMs)
how can we add expresion that will add virtual hardware versions to these VMs also?
Thanks
-
5. Re: Query Multiple vCenters for (vCenter name, Datacenter name, Cluster Name, No. of Cluster Hosts, No. of VMs)
Not sure I understand the question, the script will have an entry per cluster, not per VM.
-
6. Re: Query Multiple vCenters for (vCenter name, Datacenter name, Cluster Name, No. of Cluster Hosts, No. of VMs)
Hi LucD
thanks for reply
what I was looking for is script that will output virtual machines name, virtual hardware version, host name,cluster name and vcenter where vms running in csv format
sorry for not properly formulated question
Thanks