List VM's and their OS

[Randy_B]

It's been a while since I took the PS class and I'm just not remembering how to put these things together. I'm trying to get a list of all the VM's in my VC and what OS they are running.

After running connect-vc, I can run get-vm | select-object name and get all the VM's fine. If I run Get-VMGuest -VM (Get-VM -Name "server1") I'll get the State, IP and OS of that vm. How do I put these together?

Thanks

[Randy_B]

A little more playing with it and I answered my own question...

get-vmguest -vm (get-vm) | select-object vmname, osfullname | export-csv c:\vm_osreport.csv

[Ryan_1]

get-vm|get-vmguest|format-list

gives enough info.

[LucD]

You could combine these 2 cmlets this way

get-vm | %{
  $_ | select Name | Out-Default
  $_ | Get-VMGuest | select State, IPAddress, OSFullName | Out-Default
}

Now if you want the result in 1 object (or an array of objects) you could do

get-vm | %{
  $vm = "" | Select Name, State, IPAddress, OSFullname
  $vm.Name = $_.Name
  $guest = $_ | Get-VMGuest
  $vm.State = $guest.State
  $vm.IPAddress = $guest.IPAddress
  $vm.OSFullName = $guest.OSFullName  
  $vm
}

[Ryan_1]

export-csv always displays the IP address as system.string[].

how to get the IP displayed in csv?

[yboychev]

The reason is that the IPAddress of the vmguestInfo object is a stringArray even if it contains only 1 IP. When transfered to the csv the ToString() method is invoked therfore the result is system.string[].

Here is how you can avoid this:

 


get-vmguest -vm (get-vm)[0] | select-object vmname, osfullname, @{Name = "IPAddress"; Expression={foreach($address in $_.IPAddress){$address+=$address+ " ,"; return $address}}} | Export-CSV ... 

Yavor

[tigerdeccan]

How to get the how much RAM allocated to the VM ?

[LucD]

You can use the MemoryMB property.

Have a look at the VirtualMachine object in the PowerCLI Reference, it will show you all available properties.

[tigerdeccan]

Hi LuCD,

Thanks

Mumtaz