How to filter similar MAC addresses?

[AGFlora]

Hi

I'm trying to filter out MAC addresses but the MAC column is showing blank.

Here's what I have so far:

Get-Datacenter $DC | Get-Vm | Get-View |

Select @{N="VM";E={$_.Name}},

    @{N="#NIC";E={($_.Config.Hardware.Device | where {$_.MacAddress} | Measure-Object).Count}},

                @{N="#MAC";E={[string]::Join(',',($_.Guest.Net | %{$_.MacAddress})) | Where-Object {$_.MacAddress -like "00:50:F3*"}}},

@{N="IP addresses";E={[string]::Join('

,',($_.Guest.Net | %{$_.IpAddress}))}}

Thanks

[LucD]

Give it a try like this

Get-Datacenter $DC | Get-Vm | Get-View |
Select @{N="VM";E={$_.Name}},
@{N="#NIC";E={($_.Config.Hardware.Device | where {$_ -is [VMware.Vim.VirtualEthernetCard]} | Measure-Object).Count}},
@{N="#MAC";E={[string]::Join(',',($_.Guest.Net | where {$_.MacAddress -like "00:50:F3*"} | %{$_.MacAddress}))}},
@{N="IP addresses";E={[string]::Join(',',($_.Guest.Net | %{$_.IpAddress}))}}

[AGFlora]

Thanks Luc that worked!

[AGFlora]

Luc

After further review for some reason there are still some blanks in the MAC column for some vms that have MACs starting with 00:50:f3