Solved

which table in vcenter database saves all hosts information

Posted on 2015-01-21
6
323 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
  • 3
  • 2
6 Comments
 
LVL 119

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

829 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