Solved

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

Posted on 2015-01-26
5
246 Views
Last Modified: 2015-02-17
How to query a VMware vCenter 5.5 to get a list of all Virtual Machines provisioned and their appropriate Operating System names.
0
Comment
Question by:tech2000-usa
  • 2
  • 2
5 Comments
 
LVL 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40571655
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
 
LVL 62

Expert Comment

by:gheist
ID: 40572416
Another option is to get Quest PowerGUI and check report scripts there.
0
 

Author Comment

by:tech2000-usa
ID: 40584092
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
 
LVL 62

Expert Comment

by:gheist
ID: 40584102
You can extract respective script from powergui.
0
 
LVL 119
ID: 40584106
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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …
Teach the user how to install and configure the vCenter Orchestrator virtual appliance Open vSphere Web Client: Deploy vCenter Orchestrator virtual appliance OVA file: Verify vCenter Orchestrator virtual appliance boots successfully: Connect to the …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question