#run on VMM
$log = "C:\temp\log.csv"
$vms = get-vm | select vmhost,computername,name,cpucount,memoryassignedmb
$header = "physical host,computer name,VM name,CPU count,memory"
Add-content $log $header
foreach ($vm in $vms) {
    [string]$content = $vm.vmhost.name+";"+$vm.computername+";"+$vm.name+";"+$vm.cpucount+";"+$vm.memoryassignedmb
    Add-content $log $content
}