Ok, so here is the command you can use to get the VM Name, Guest OS Details and Datacenter Details...
Get-VM | Select Name, Guest, @{N="Datacenter";E={Get-Datacenter -VM $_}}
To export the result in CSV, you can use it like below:
Get-VM | Select Name, Guest, @{N="Datacenter";E={Get-Datacenter -VM $_}} | Export-Csv D:\Test.CSV
Thanks,
Amit
