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
Solved

Need to export info on vm's for reporting

Posted on 2010-08-24
5
343 Views
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?

Thx
0
Comment
Question by:jkit001
5 Comments
 
LVL 6

Accepted Solution

by:
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)
http://www.foundstone.com/us/resources/proddesc/vidigger.htm
and user manual
http://www.foundstone.com/us/resources/whitepapers/wp_vidigger_user_manual.pdf
It currently only works on ESX 3.x but that should be okay for you--just something to keep in mind.
0
 
LVL 8

Assisted Solution

by:ConUladh
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
0
 
LVL 6

Assisted Solution

by:Joshua1909
Joshua1909 earned 125 total points
ID: 33509876
There are also commercial programs available like:
http://www.veeam.com/vmware-esx-reporter.htm
Lots of export options:
http://www.veeam.com/vmware-esx-reporter.html#fragment-2
0
 
LVL 28

Assisted Solution

by:bgoering
bgoering earned 62 total points
ID: 33510163
You can also use VMware's RCLI (http://www.vmware.com/downloads/download.do?downloadGroup=VI-RCLI-U2
) to do all kind of things.


vmware-cmd -l > machinelist.txt

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

Author Closing Comment

by:jkit001
ID: 33537440
x
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

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.
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.
Teach the user how to delpoy the vCenter Server Appliance and how to configure its network settings Deploy OVF: Open VM console and configure networking:
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…

856 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