?
Solved

Need to export info on vm's for reporting

Posted on 2010-08-24
5
Medium Priority
?
347 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
[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
5 Comments
 
LVL 6

Accepted Solution

by:
Joshua1909 earned 375 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 189 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 375 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 186 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

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
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 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…
Suggested Courses

771 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