Need to export info on vm's for reporting

Posted on 2010-08-24
Last Modified: 2012-05-10
I have vmware esx 3.x.  I need to do reporting with spreadsheets.  Is there a way to export out a list of the vm names in my vm servers and it's associated server names, description, etc...?

Any how-to's out there?

Question by:jkit001
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

Accepted Solution

Joshua1909 earned 125 total points
ID: 33509769
This tool is very good and will export a LOT of information about your esx hosts, ,configuration, misconfigurations, etc. (and it's free)
and user manual
It currently only works on ESX 3.x but that should be okay for you--just something to keep in mind.

Assisted Solution

ConUladh earned 63 total points
ID: 33509840
You could also query the underlying database directly if you have any SQL database tools /reporting software installed.

I can query our Virtual Centre databse from SQL Server Management Studio for example

Assisted Solution

Joshua1909 earned 125 total points
ID: 33509876
There are also commercial programs available like:
Lots of export options:
LVL 28

Assisted Solution

bgoering earned 62 total points
ID: 33510163
You can also use VMware's RCLI (
) to do all kind of things.

vmware-cmd -l > machinelist.txt

Will get a list of machines that you could put into a spreadsheet.

Author Closing Comment

ID: 33537440

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Inventory reset. 1 50
The better OS Architecture 13 87
security id structure is invalid 2 85
Esxi host patches. 5 45
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
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 Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

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