which table in vcenter database saves all hosts information

I have three vcenter servers, in every environment there are 30-40 hosts. My boss asked me to make a spreedsheet of all hardware spec of all hosts. How can I do it fast?

I can see the spec from the summary tab, but I can't copy paste or export it out. I want to get a fast way. since I have access to the backend database, I think I can do it through the database.

Thank you.
Jason YuAsked:
Who is Participating?
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
If you want to do it FAST.... download and use RV Tools from


This is a standalone application which uses your username and password to connect to vCenter Server, and quickly collects all the data, and you can export to Excel, in seconds for a quick report!

This is the vHosts tab, which I think this is the output you require for your boss!

vHosts by RV Tools!
You could always tell him, it took you all day, and go for an early lunch, or coffee!!!
Uni KittyCommented:
You could always tell him, it took you all day, and go for an early lunch, or coffee!!!

Jason YuAuthor Commented:
It works great, thank you very much.
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Jason YuAuthor Commented:
Sure, that's a good advise.
Jason YuAuthor Commented:
quick respond and right answer!
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
No problems now go for that coffee! Always here at EE, to save you time!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.