-
1. Re: Query Multiple vCenters for (vCenter name, Datacenter name, Cluster Name, No. of Cluster Hosts, No. of VMs)
faherne_CTI Nov 21, 2017 8:55 AM (in response to faherne_CTI)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)
LucD Nov 21, 2017 9:12 AM (in response to faherne_CTI)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)
faherne_CTI Nov 22, 2017 7:04 AM (in response to LucD)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)
PandzicM Jun 1, 2019 9:24 AM (in response to faherne_CTI)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)
LucD Jun 1, 2019 10:10 AM (in response to PandzicM)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)
PandzicM Jun 1, 2019 10:22 AM (in response to LucD)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