I've been working with SQL again and wanna share this query. It displays all clusters and their hosts. Now, I know you can do this easy in Powershell - but I was looking at a different aproach, without connecting to my ESX server. Since all data is still in the database - I can query it here.

So here is the query, extend, discover and learn :

select F.NAME, E.NAME
from dbo.VPX_ENTITY E
left join dbo.VPX_ENTITY F
on E.PARENT_ID = F.ID
where F.TYPE_ID = 3 and E.TYPE_ID = 1
order by F.NAME