How to query a VMware vCenter 5.5 to get a list of all Virtual Machines provisioned and their appropriate Operating System names.

How to query a VMware vCenter 5.5 to get a list of all Virtual Machines provisioned and their appropriate Operating System names.
tech2000-usaAsked:
Who is Participating?
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
The quickest way to do this, is to download RV Tools from http://www.robware.net/


Install, Run it, connect to your vcenter server, with username and password and export to Excel!

vInfo-RVTools
The other option using vCenter Server, connect to vCenter using vSphere Client....

Click your Datacenter, Click the virtual machines Tab..

Click the Top Gray Bar, and select Guest OS, and then click the white space, and Export to CSV....

Step 1 - Select columns for export
Step 2 - Right Click Whitespace, and select Export (CSV, HTML etc)
0
 
gheistCommented:
Another option is to get Quest PowerGUI and check report scripts there.
0
 
tech2000-usaAuthor Commented:
Thanks for suggested solutions. I am already using RV Tools and VMware vSphere Client to get such report. I was looking for a command line solution so I can include in a PowerShell script; something like the following PowerShell command:

get-vm | get-VMGuest | Select-Object VMname, osfullname

-Massoud
0
 
gheistCommented:
You can extract respective script from powergui.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
You did not state you wanted a Powershell script in the opening question.

Get-View -ViewType "VirtualMachine" -Property @("Name", "Config.GuestFullName", "Guest.GuestFullName") |`
 Where-Object {($_.Config.GuestFullName -ne $_.Guest.GuestFullName) -and `
  ($_.Guest.GuestFullName -ne $null)} | `
 Select-Object -Property Name, @{N="Configured OS";E={$_.Config.GuestFullName}}, `
  @{N="Running OS";E={$_.Guest.GuestFullName}} | `
 Format-Table -AutoSize

Open in new window


source
https://boerlowie.wordpress.com/2011/07/27/find-vms-with-mismatched-os-using-powercli/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.