This should help in exactly what you want.. Just you need to work on CSV file alignment little-bit.. ![]()
Refer the to the command section of this article (Step-3).
Get-VM | select Name, Guest | Export-CSV D:\test.csv
It should do for you. I am not sure if Datacentre column can be fit in the report.. will try and let you know..
Thanks,
Amit