VMware Cloud Community
cksmith
Contributor
Contributor

Pulling out information from SQL database

Is there a way to walk through the database and get all of the objects and their configurations that are seen by the vSphere client? I am working on automating some of the configuration/setup and need to find a way of storing as much about the configurations as possible so that I can use this information to restore the configs after upgrade or for a new install. If someone knows anything about accessing this info from the vCenter Servers database, your input is greatly appreciated.

Reply
0 Kudos
3 Replies
Troy_Clavell
Immortal
Immortal

cksmith
Contributor
Contributor

Thanks for the info on the database views. This document looked like it had a lot of good info about the database views but didnt tell how to use/view/create them. Is there a document that specifies how to create/use database views?

Reply
0 Kudos
ElioteArg
Contributor
Contributor

Hello,

Is it possible to "export" some data from the SQL database? For example, I'd like to have an Excel file which shows in which ESXi Host a Virtual Machine is. Let me make ir clearer: I want to have all the info of every virtual machine in a table. Does anyone has an idea?

Reply
0 Kudos