?
Solved

which table in vcenter database saves all hosts information

Posted on 2015-01-21
6
Medium Priority
?
340 Views
Last Modified: 2015-01-21
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.
0
Comment
Question by:Jason Yu
[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
  • 3
  • 2
6 Comments
 
LVL 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 40562278
If you want to do it FAST.... download and use RV Tools from

http://www.robware.net/

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!!!
0
 
LVL 5

Expert Comment

by:Uni Kitty
ID: 40562351
You could always tell him, it took you all day, and go for an early lunch, or coffee!!!

^^
Brilliant!
0
 

Author Comment

by:Jason Yu
ID: 40562423
It works great, thank you very much.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:Jason Yu
ID: 40562427
Sure, that's a good advise.
0
 

Author Closing Comment

by:Jason Yu
ID: 40562431
quick respond and right answer!
0
 
LVL 123
ID: 40562438
No problems now go for that coffee! Always here at EE, to save you time!
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

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: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…
Suggested Courses

765 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