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]

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!

[murugan071]

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

Thank you

[LucD]

Yes, just add a calculated property

@{N='MAC';E={$_.MacAddress}},

 

[murugan071]

Tried the below script but got an empty MAC column. Am I missing something here?

Get-VM | Select Name,VMHost, @{N='MAC';E={$_.MacAddress}}, @{N="IP Address";E={@($_.guest.IPAddress[0])}} |
Export-Csv -NoTypeInformation C:\PS\1machine1_ip.csv

Also, is it possible to get every IP/MAC assigned to the farm machines?

Thank you,

[LucD]

I was referring to this script

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

[murugan071]

This one worked just fine! Thanks a lot, once again!

[Monte0185]

I know this was made awhile back but i was hoping you could help out again. Could you could remove the host column, add the Guest OS Type, and Powered on State? The rest is working wonderfully but I need those columns for a report I'm building.  Your original script that added the IP's into their own columns was almost perfect for what I needed.

$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 D:\Powershell\Logs\TestIP_1.csv -NoTypeInformation -UseCulture

[LucD]

Try like this

$report = foreach ($vm in Get-VM) {
  $obj = [ordered]@{
    Name = $vm.Name
    PowerState = $vm.PowerState
    GuestOS = $vm.Guest.OSFullname
  }
  $i = 1
  $vm.Guest.IPAddress | ForEach-Object {
    $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

[Monte0185]

That is awesome. I was looking all over for those 2 commands. Is it possible for guest name to be the FQDN?

[LucD]

Sure, try like this

$report = foreach ($vm in Get-VM) {
  $obj = [ordered]@{
    Name = $vm.Name
    FQDN = $vm.Guest.HostName
    PowerState = $vm.PowerState
    GuestOS = $vm.Guest.OSFullname
  }
  $i = 1
  $vm.Guest.IPAddress | ForEach-Object {
    $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

[Monte0185]

Thank you Very much!!

[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!

[Hernan Rojas]

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

[devarshi_singh]

hi  
I tried:

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

and all other programs given below but none seems to be working, probably because Guest field is empty for my VM output.
I have to take these files and further I can export them to csv. Exporting to CSV, I know how it's done but all these vm files I am getting only name but No IP Address.

Sample Output or Get-Vm | Format-List in Powershell ISE
Name : VM_5360
PowerState : PoweredOn
Notes :
Guest :
NumCpu : 1
CoresPerSocket : 1
MemoryMB : 4096
MemoryGB : 4
VMHostId :
VMHost :
VApp :
FolderId :
Folder :
ResourcePoolId :
ResourcePool :
HARestartPriority : ClusterRestartPriority
HAIsolationResponse : AsSpecifiedByCluster
DrsAutomationLevel : AsSpecifiedByCluster
VMSwapfilePolicy :
VMResourceConfiguration : CpuShares:Normal/1000 MemShares:Normal/40960
Version :
PersistentId :
GuestId :
UsedSpaceGB :
ProvisionedSpaceGB :
DatastoreIdList :
ExtensionData : VMware.Vim.VirtualMachine
CustomFields : {}
Id : VirtualMachine-vm-1893
Uid : /VIServer=vsphere.local\administrator@100.100.10.97:443/VirtualMachine=VirtualMachine-vm-1893/


Powershell Version: 

PS C:\Users\Administrator> $PSVersionTable

Name Value
---- -----
PSVersion 5.1.20348.1366
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.20348.1366
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

And PowerCLI version:

PS C:\Users\Administrator> gET-pOWERclivERSION
WARNING: The cmdlet "Get-PowerCLIVersion" is deprecated. Please use the 'Get-Module' cmdlet instead.

PowerCLI Version
----------------
VMware PowerCLI 10.0.0 build 7895300
---------------
Component Versions
---------------
VMware Cis Core PowerCLI Component PowerCLI Component 10.0 build 7893915
VMware VimAutomation VICore Commands PowerCLI Component PowerCLI Component 10.0 build 7893909

 

PS C:\Users\Administrator> $Global:DefaultVIServers | select Name, Version, Build

Name Version Build
---- ------- -----
100.100.10.97 8.0.1 21201873


ESXi Being Used on which VM are hosted: 7.0.3 (1e)

 

[LucD]

If the VMware Tools are not installed there will be no info under the Guest property.

[devarshi_singh]

Thanks  ,
I updated VmWareTools and it now works fine for me now.
Keep shining