Solved

which table in vcenter database saves all hosts information

Posted on 2015-01-21
6
335 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 121

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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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

Featured Post

Threat Trends for MSPs to Watch

See the findings.
Despite its humble beginnings, phishing has come a long way since those first crudely constructed emails. Today, phishing sites can appear and disappear in the length of a coffee break, and it takes more than a little know-how to keep your clients secure.

Question has a verified solution.

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

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

687 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