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
237 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 118

Accepted Solution

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

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 61

Expert Comment

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Teach the user how to configure vSphere Replication and how to protect and recover VMs Open vSphere Web Client: Verify vsphere Replication is enabled: Enable vSphere Replication for a virtual machine: Verify replicated VM is created: Recover replica…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

932 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

12 Experts available now in Live!

Get 1:1 Help Now