Database - how to access Cluster info?

[Barry_G]

I am pulling info from SQL Server 2008 DB into a virtual machine report using Crystal Reports and need to group the vm's by Cluster.  Can somebody please point me to what table-field the Cluster info is stored?  FWIW, we're running vCenter 5.1

Alternately, is there a good online guide anywhere to the database structure?

TIA

[admin]

Check in table vpx_entity

[Barry_G]

Thanks.  That will give me a list of clusters.  Where is the link between VM/Host and cluster?

[admin]

That table wont be there since Host and VM are equal objects in the hierarchy...

[admin]

Please mark my answer as helpful or correct if it guided you...