Hi.
Is there a way to list the vCenter a VM is located on?
See script below;
I need a column in the output csv that lists out the vCentername of each VM.
I have listed it manually until now (see RED line in script), but I need it to be automated
#Connect to vCenter1
Connect-VIserver vcenter1.test.com -User reporter@vsphere.local -Password xxxxx Get-VM |
select Name,
@{N="DNSName";E={$_.ExtensionData.Guest.Hostname}},
@{N="vCenter";E={'VCENTERNAME'}},
@{Name=’Cluster’;Expression={$_.VMHost.Parent}},
VMHost,
@{N="Datastore";E={$_.ExtensionData.Config.DatastoreUrl.Name}},
ResourcePool,
@{N="Tools Installed";E={$_.Guest.ToolsVersion -ne ""}},
@{N="Tools Version";E={if($_.Guest.ToolsVersion -ne ""){$_.Guest.ToolsVersion}}},
@{N="Tools Status";E={$_.ExtensionData.Guest.ToolsStatus}},
Notes
|
Export-Csv "C:\Reporting\VMreport.csv" -NoTypeInformation
Disconnect-VIServer * -force -confirm:$false
#
#Connect to vCenter2
Connect-VIserver vcenter2.test.com -User reporter@vsphere.local -Password xxxxx Get-VM |
select Name,
@{N="DNSName";E={$_.ExtensionData.Guest.Hostname}},
@{N="vCenter";E={'VCENTERNAME'}},
@{Name=’Cluster’;Expression={$_.VMHost.Parent}},
VMHost,
@{N="Datastore";E={$_.ExtensionData.Config.DatastoreUrl.Name}},
ResourcePool,
@{N="Tools Installed";E={$_.Guest.ToolsVersion -ne ""}},
@{N="Tools Version";E={if($_.Guest.ToolsVersion -ne ""){$_.Guest.ToolsVersion}}},
@{N="Tools Status";E={$_.ExtensionData.Guest.ToolsStatus}},
Notes
|
Export-Csv "C:\Reporting\VMreport.csv" -NoTypeInformation -Append