This script is pretty handy, it will connect to the Virtual Center you specify in Powershell.<\/p>\n
# you will need to adjust the viserver name
\nconnect-viserver someserver.eu.kellogg.com<\/p>\n
$reportedvms=New-Object System.Collections.ArrayList
\n$vms=get-view -viewtype virtualmachine |Sort-Object -Property { $_.Config.Hardware.Device | where {$_ -is [VMware.Vim.VirtualEthernetCard]} | Measure-Object | select -ExpandProperty Count} -Descending<\/p>\n
foreach($vm in $vms){
\n$reportedvm = New-Object PSObject
\nAdd-Member -Inputobject $reportedvm -MemberType noteProperty -name Guest -value $vm.Name
\nAdd-Member -InputObject $reportedvm -MemberType noteProperty -name UUID -value $($vm.Config.Uuid)
\n$networkcards=$vm.guest.net | ?{$_.DeviceConfigId -ne -1}
\n$i=0
\nforeach($ntwkcard in $networkcards){
\nAdd-Member -InputObject $reportedvm -MemberType NoteProperty -Name “networkcard${i}.Network” -Value $ntwkcard.Network
\nAdd-Member -InputObject $reportedvm -MemberType NoteProperty -Name “networkcard${i}.MacAddress” -Value $ntwkcard.Macaddress
\nAdd-Member -InputObject $reportedvm -MemberType NoteProperty -Name “networkcard${i}.IpAddress” -Value $($ntwkcard.IpAddress|?{$_ -like “*.*”})
\nAdd-Member -InputObject $reportedvm -MemberType NoteProperty -Name “networkcard${i}.Device” -Value $(($vm.config.hardware.device|?{$_.key -eq $($ntwkcard.DeviceConfigId)}).gettype().name)
\n$i++
\n}
\n$reportedvms.add($reportedvm)|Out-Null
\n}<\/p>\n
$reportedvms|Export-Csv c:myreport.csv<\/p>\n","protected":false},"excerpt":{"rendered":"
This script is pretty handy, it will connect to the Virtual Center you specify in Powershell. # you will need to adjust the viserver name connect-viserver someserver.eu.kellogg.com $reportedvms=New-Object System.Collections.ArrayList $vms=get-view -viewtype virtualmachine |Sort-Object -Property { $_.Config.Hardware.Device | where {$_ -is [VMware.Vim.VirtualEthernetCard]} | Measure-Object | select -ExpandProperty Count} -Descending foreach($vm in $vms){ $reportedvm = New-Object PSObject … <\/p>\n