Query VCenter SQL DB For Cluster Data

[Duckfather]

Hi all

I need to be able to query the VCenter DB (SQL2005, VC2.5 U4) for a list of Clusters in a particular DataCenter for a 3rd party app.

Does anyone know the SQL that I could throw at the DB to get this info?

Cheers in advance.

Andy

[Troy_Clavell]

what kind of information are you looking for? Why query the DB? Is this something you can get using maybe PowerCLI?

[Duckfather]

As a minimum, just the Cluster name. Ideally, all data in the VPX_COMPUTE_RESOURCE table (ie all cluster data).

I can get this for the entire VCenter, but I'm unable to work out how to get this data for a particular Datacenter (the above table holds no references to Datacenters).

The reason I'm querying the DB directly is that I'm developing a simplified web interface to provide summary data to our management. I can get almost everything apart from Cluster data per Datacenter.