Multiple data subjects (Virtual Machine and Host System) in the same view/report

[MickOToole]

Hi I am looking for some hlp with creating a view in VROPS that will  show a combination of Virtual Machine Information and host information in the same view. 

headings would be as: 

VM Name, VM OS, Underlying Host, Number of host Sockets, Number of Host physical cores

so the first two headings are virtual; machine information and the rest is information relation to the host that the actual virtual machine would reside. i want to have this information all in the same row in the view. its the relationship between the VM and host that i can figure out how to corelate. 

i have attached an image of what i want the actual report to look like. 

Any help would be greatly appreciated. 

[FredGSanford · Accepted solution]

Here is an option

https://www.brockpeterson.com/post/vrops-views-for-multiple-objects

[MickOToole]

Thanks very for that Fred. Exactly what i was looking for. surprised that the relationship can no be done in the view rather than the supermetric.