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
235 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 117

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
Comment Utility
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 61

Expert Comment

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

Author Comment

by:tech2000-usa
Comment Utility
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 61

Expert Comment

by:gheist
Comment Utility
You can extract respective script from powergui.
0
 
LVL 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Join & Write a Comment

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.
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
Teach the user how to install ESXi 5.5 and configure the management network System Requirements: ESXi Installation:  Management Network Configuration: Management Network Testing:
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now