Duplicate Values when querying from multiple vCenters

[ganapa2000]

Hi,

I am getting duplicate values from exporting the information from multiple vcenters. Please help.

$vCenters = @(
"vcenter1"
"vcenter2"
)
Connect-viserver -Server $vCenters

$vmfreeInfo = Foreach ($vc in $global:DefaultVIServers)
{
ForEach ($VM in get-folder "Release" | Get-VM)
{
($VM.Extensiondata.Guest.Disk | Select @{N='vCenter';E={([uri]$VM.ExtensionData.Client.ServiceUrl).Host}},
@{N="Name";E={$VM.Name}},
@{N="IP Address";E={$VM.guest.IPAddress[0]}},
@{N="VM PowerState";E={@($VM.PowerState)}},
@{N="OS"; E={@($VM.guest.OSFullName)}},
@{N="Folder";E={$VM.Folder.Name}},
@{N="MountPoint";E={$_.DiskPath}},
@{N="Capacity(GB)";E={[math]::Round($_.Capacity/ 1GB)}},
@{N="FreeSpace(GB)";E={[math]::Round($_.FreeSpace / 1GB)}},
@{N="FreeSpace(%)";E={[math]::Round(((100* ($_.FreeSpace))/($_.Capacity)),0)}},
@{N="UsedSpace(GB)";E={[math]::Round(((($_.Capacity / 1GB))-($_.FreeSpace / 1GB)),0)}})
}
}
$vmfreeInfo | ft -auto

[LucD · Accepted solution]

You could start by adding the Server parameter on the cmdlets.

[ganapa2000]

Hi LucD,

I edited the below line as below. It worked.

ForEach ($VM in get-folder "Release" -server $vc | Get-VM -server $vc)

Thank you very much for your help 🙂