Get List of IP addresses for each VM

[antoniogemelli]

Hello,

I have a script to get Ip address and vm name:

Get-VM | Select Name,VMHost, @{N="IP Address";E={@($_.guest.IPAddress[0])}} |

Export-Csv -NoTypeInformation C:\Users\gemela\Desktop\machine_ip.csv

I get only one IP, I want to get also management ip and backup ip.

Is possible? ideally will be nice to get all IP for each machine.

Thanks

[LucD · Accepted solution]

You can join the elements of the array together in one string.

Like this

Get-VM |

Select Name,VMHost, @{N="IP Address";E={@($_.guest.IPAddress -join '|')}} |

Export-Csv -NoTypeInformation C:\Users\gemela\Desktop\machine_ip.csv

[antoniogemelli]

Thanks a lot LucD

[antoniogemelli]

Hi LucD

With this script I got all IP for each VM,

But when generating csv all of them are in one line (separated with pipe)

Is possible to configure the script to get 3 different column?

Thanks

[LucD]

Try something like this

$report = foreach($vm in Get-VM){

    $obj = [ordered]@{

        Name = $vm.Name

        Host = $vm.VMHost.Name

    }

    $i = 1

    $vm.Guest.IPAddress | %{

        $obj.Add("IP$($i)",$_)

        $i++

    }

    New-Object PSObject -Property $obj

}

$report | Sort-Object -Property {($_ | Get-Member -MemberType Properties).Count} -Descending |

Export-Csv C:\Users\gemela\Desktop\machine_ip.csv -NoTypeInformation -UseCulture

[antoniogemelli]

This give me only an empty column, no result.

[LucD]

There were some typos in there, I corrected the code above.

[PDpd]

Hi

Can you also suggest getting all IPs in separate rows and not columns? If a server has 3 IPs,  I will ike to see a report with 3 rows and not 3 columns. 

Thanks!

[LucD]

Sure, try like this

$report = foreach($vm in Get-VM){

    foreach($ip in $vm.Guest.IPAddress){

        $obj = [ordered]@{

            Name = $vm.Name

            Host = $vm.VMHost.Name

            IP = $ip

        }

        New-Object PSObject -Property $obj

    }

}

$report | Sort-Object -Property {($_ | Get-Member -MemberType Properties).Count} -Descending |

Export-Csv C:\Users\gemela\Desktop\machine_ip.csv -NoTypeInformation -UseCulture

[wowitsdave]

@LucD - very helpful! Thanks!

[mcity]

How do I modify this script to list VM tag name for a certain Category?

[LucD]

Add a property with the result of the Get-TagAssignment cmdlet.

Note that this property will be repeated for each IP address

[mcity]

I am using the script below, where do I add the Get-Assignment for tag Category Backup, for example?

Get-VM |

Select Name,VMHost, @{N="IP Address";E={@($_.guest.IPAddress -join '|')}} |

Export-Csv -NoTypeInformation C:\Users\gemela\Desktop\machine_ip.csv

[LucD]

You could do something like this

Get-VM |

Select Name,VMHost,

    @{N="IP Address";E={@($_.guest.IPAddress -join '|')}},

    @{N='Tag';E={(Get-TagAssignment -Entity $_ -Category 'Backup').Tag.Name}} |

Export-Csv -NoTypeInformation C:\Users\gemela\Desktop\machine_ip.csv

[mcity]

Exactly what I needed, thanks LucD@

[ad_astra_777]

What should be added to this script in order to get the network the VM is attached to?

[LucD]

You could do something like this

Get-VM -PipelineVariable VM | ForEach-Object -Process {

    $vm.Guest.Nics |

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

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

        @{N='Network';E={$_.NetworkName}},

        @{N="IP Address";E={$_.IPAddress -join '|'}}

} | Export-Csv -NoTypeInformation C:\Users\gemela\Desktop\machine_ip.csv

[ad_astra_777]

Absolutely brilliant, thank you!

[erojasmu]

Hi. 

Thank you for your code. It works like a charm. I was wondering if you can try to convert it from the "Get-VM" cmdlet to "Get-View". I was trying but I got stuck at some point.

Thank you in advance for your suggestions.

Hernan

[murugan071]

Is it possible to get MAC address too with IP details here?

Thank you