List all IP addresses in new line

[ganapa2000]

Hi,

Please help to get the list of all the IP Address in new or different lines

Get-VM db1 | Select @{N='VM Name';E={$_.Name}}, @{N="IP Address";E={[string]::Join(',',$_.guest.IPAddress)}}

Current Output

VM Name                                                                                             IP Address
-------                                                                                             ----------
db1                                                                                                 169.254.1.40,192.168.2.99

I would like to get output as below

VM Name                          IP Address
-------                                ----------
db1                                   169.254.1.40

db1                                   192.168.2.99

Please help!!!!

[LucD · Accepted solution]

Try like this

Get-VM -Name db1 -PipelineVariable vm |

ForEach-Object -Process {

    $_.guest.IPAddress |

    Select @{N='VM Name';E={$vm.Name}},

        @{N="IP Address";E={$_}}

}

[ganapa2000]

Thank you very much