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
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 121

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 121
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Last article we focus in how to VMware: How to create and use VMs TAGs ā€“ Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four vā€¦
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

728 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