You want a view showing VMs, the ESXi Hosts they are on, the Clusters they are in, and properties and metrics for each. Yep, we can do it, and it'll end up looking something like this!
When I first tried doing this, I created a View using multiple objects, thinking the relationships would be made, but they aren't.
While all Objects are included, they aren't all on the same line, no relationships are being made. Parent ESXi Host and Parent Cluster are available properties on the VM object, so those are easy, but the ESXi Host and Cluster properties I wanted aren't. So, Super Metrics!
Super Metrics are powerful, in that you can perform functions on metrics, ie total them, take averages, etc. You can also use Super Metrics to attach metrics or properties from related objects to a target, in this case a VM.
I created Super Metrics on the VMs as follows, but you can use this same methodology to create others as well:
Parent ESXi Host CPU Packages
Parent ESXi Host CPU Cores
Parent Cluster DRS Status
Parent Cluster Physical CPUs
Parent Cluster Usable CPUs
This effectively attaches the ESXi Host and Cluster metrics and properties you want to the VM object, making them available in your View. Now, when I go to create my View, I have everything I need.
I've uploaded these Super Metrics to VMware {code}. Feel free to download and make them your own. Hopefully this helps!