Solved

which table in vcenter database saves all hosts information

Posted on 2015-01-21
6
328 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 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 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
Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

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 120
ID: 40562438
No problems now go for that coffee! Always here at EE, to save you time!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

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.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

726 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