next »

[esarakaitis]

Code:

$VMs = get-vmhost | Get-VM
foreach ($VM in $VMs){
    $VMx = Get-View $VM.ID
$HW = $VMx.guest.net
foreach ($dev in $HW)
    {
        foreach ($ip in $dev.ipaddress)
        {
            $dev | select @{Name = "Name"; Expression = {$vm.name}},@{Name = "IP"; Expression = {$ip}}, @{Name = "MAC"; Expression = {$dev.macaddress}}
        }
    }
}

[aflora]

Hi

When I try to pipe this script to a csv file I get the folowing error:
"Cannot bind argument to parameter 'InputObject' because it is null"
The script returns this error but creates the csv file with the data none the less?
Must be a data format quirk when exporting to a csv file. Works with no errors when I use html format.

$report =@()
$VMs = get-vmhost | Get-VM
foreach ($VM in $VMs){
    $VMx = Get-View $VM.ID
   $HW = $VMx.guest.net
   foreach ($dev in $HW)
    {
        foreach ($ip in $dev.ipaddress)
        {
       $report +=  $dev | select @{Name = "Name"; Expression = {$vm.name}},@{Name = "IP"; Expression = {$ip}}, @{Name = "MAC"; Expression = {$dev.macaddress}}
        }
    }
}
$report | export-csv -NoType d:\VmReport.csv

[esarakaitis]

wonder if its a bug, because i'm getting the same results  you are, regardless of what i try

[alanrenouf]

Try this:

Code:

$Report = @()
$VMs = get-vmhost | Get-VM
foreach ($VM in $VMs){
   $VMx = Get-View $VM.ID
   $HW = $VMx.guest.net
   foreach ($dev in $HW)
    {
        foreach ($ip in $dev.ipaddress)
        {
      $MyDetails = "" | select-Object Name, IP, MAC
$MyDetails.Name = $vm.name
$MyDetails.IP = $ip
$MyDetails.MAC = $dev.macaddress
$Report += $MyDetails
        }
    }
}
$report | export-csv -NoType C:\VmReport.csv

[aflora]

Thanks...this works with no errors. Thanks for your help. Your site and scripts are very useful.