So far what I have done it ran a nested for each loop on the output of get-view -viewtype hostsystem with a bunch of filters and properties defined.

Using the loop, I stored the host's .name value against the VMs .MoRef value in a hash table which seems to be created very quickly within the nested for each loops.

Now I use reference the hash table while I loop through my VMs to get their corresponding host.

I'm open to cleaner ideas if anyone has any thoughts?