Set-PowerCLIConfiguration -DefaultVIServerMode Multiple -Scope User -Confirm:$false
Set-PowerCLIConfiguration -InvalidCertificateAction Ignore -Scope User -Confirm:$false
#$cred = Get-Credential Domain\username
Connect-VIServer VCenter-Name -Credential $cred -force
& { foreach ($vCenterServer in $DefaultVIServers)
{
$VMHostTable= @{}
foreach ($VMHostView in (Get-View -Server $vCenterServer -ViewType HostSystem -Property Name))
{
$VMHostTable[“$($VMHostView.MoRef.Value)”] = $VMHostView.Name
}
$DatastoreTable = @{}
foreach ($DatastoreView in (Get-View -Server $vCenterServer -ViewType Datastore -Property Name))
{
$DatastoreTable[“$($DatastoreView.MoRef.Value)”] = $DatastoreView.Name
}
Get-View -Server $vCenterServer -ViewType VirtualMachine -Filter @{“Config.Template”=”False”} -Property Name,
Runtime.Host,
Guest.GuestFullName,
Runtime.PowerState,
Guest.IPAddress,
Guest.Net,
Config.Annotation,
Datastore,
Config.Tools.ToolsVersion |
Select-Object -Property @{N=”vCenter”;E={$vCenterServer.Name}},
@{N=”VMHost”;E={$VMHostTable[“$($_.Runtime.Host.Value)”]}},
@{N=”VM”;E={$_.Name}},
@{N=”Powerstate”;E={$_.Runtime.PowerState}},
@{N=”Guest OS”;E={$_.Guest.GuestFullName}},
@{N=”IP Address”;E={@($_.Guest.IPAddress)}},
@{N=”MACAddress”;E={$_.guest.net.Macaddress}},
@{N=”Datastores”;E={
$DatastoreNames = foreach ($Datastore in ($_.Datastore))
{$DatastoreTable[“$($Datastore.Value)”]}
[string]::Join(‘,’,($DatastoreNames))}
},
@{N=”VMware Tools version”;E={$_.Config.Tools.ToolsVersion}},
@{N=”Notes”;E={$_.Config.Annotation}}
}} |
Export-Csv -Path “c:\temp\VMsInfo-$(Get-Date -UFormat ‘%Y%m%d-%H.%M.%S’).csv” -NoTypeInformation -UseCulture
#Get-View -Server $vCenterServer -ViewType VirtualMachine -Filter @{“Config.Template”=”False”} -Property Name, @{N=”IP Address”;E={@($_.Guest.IPAddress)}}
