script for export list of the virtual machines from vCentre

PowerShell -PSConsoleFile "C:\Program Files\VMware\Infrastructure\vSphere PowerCLI\vim.psc1" -command M:\_ServiceRequests\VMware\Scripts\VMwareExport.ps1

$vcserver="wfcp3507"
connect-VIServer $vcserver

$report = @()
Get-VM | %{
$vm = $_ | Get-View
$row = "" | Select Name, State, Status, Host, CPU, Memory, GuestMem, Notes
$row.Name = $_.Name
$row.State = $_.PowerState
$row.Status = $vm.Summary.OverallStatus
$row.Host = $_.Host
$row.CPU = $vm.Summary.QuickStats.OverallCpuUsage
$row.Memory = $vm.Summary.QuickStats.HostMemoryUsage
$row.GuestMem = ("{0:f0}" -f ($vm.Summary.QuickStats.GuestMemoryUsage / $_.MemoryMB * 100))
$row.Notes = $_.Description
$report += $row
}

$report | Export-Csv "Q:\Engineer\VMWare Resource Manager\VMwareExport.csv" -noTypeInformation

##############################

1. Disconnect session from VC #

##############################

disconnect-viserver -confirm:$false