How to Export your VM Inventory list from vCenter
Time will come when you need a quick inventory of the VMs in your vCenter with their IPs, Computer name, power on status & all these simple things. You might just need that sheet b/c you need to keep an inventory of what you have or just the for the simple cause that the management had asked you for such one. In both cases you need to figure out the quickest and easiest way to do it. Yeah this can be achieved using power shell script or any other scripting language that vSphere support, but let’s keep that to when we require a more extensive inventory that is can not be generated using the GUI of vCenter. One question I repeatedly hear “why is the Export list in vCenter file menu is shadowed and can not be chosen?” Here I will show you the steps to get a simple inventory of your VMs using VMware vCenter GUI & following it will show you how to get the Export list in vCenter file menu in business.
Steps to Export your VM Inventory list from VMware vCenter
1- Open the vSphere Client and connect to your vCenter
2- From the top menu go to View ==> Inventory ==> VMs & Templates
3- From the inventory list on the left side choose the VMs you want to include in your inventory export or choose a top level folder that includes the VMs you want to export
4- Choose the Virtual Machines tab from the the tabs on the top of the right side.
5- You might want to modify the filter to include other items like Virtual machines IPs, Hostname, & the similar.
6- From the top menu go to File => Export => Export list.
7- Choose the format you want to save the list into (CSV, Html, & XML are some of the available format).
Note: You can repeat the above steps for exporting hosts inventory in vCenter and the similar as well!
I hope this help someone save time on generating such inventory list without having to write a single command. For an extra exercise you can try to generate the same with Powershell script and see how much longer it will take you to write such a script
.
Be Sociable, Share!
Tweet






March 5th, 2012 at 7:28 pm
Nice little tip. Suprising how often people don’t know that you can create filtered lists and export them.
Another great alternative is RV Tools. http://www.robware.net/
March 6th, 2012 at 1:02 pm
Hi Clayton,
Thanks for your great contribution. Actually I have never used the RV Tools before, though look quite interesting and will for sure give it a try sometime.
Regards,
Eiad
May 2nd, 2012 at 8:25 pm
Hi Clayton.
Thanks for your tutorial.
i have other question. how can I extract this lists but with the mac adress of each VM.
Thanks so much
May 8th, 2012 at 4:28 pm
Eiad…we tried our best down here in MENA to extract it for one of our customers in Qatar… but we failed… very useful indeed
May 11th, 2012 at 1:56 pm
Hi Motaz,
Glad you got to benefit of it. I really miss you guys
.
Enjoy,
Eiad
October 12th, 2012 at 10:27 am
Thanks for the great advice! Works really well!
April 8th, 2013 at 5:40 am
How to pull 2nd vNIC details from VC?