vm removed last 30 days

[esxi1979]

Get-VM -Location XX  | Get-VIEvent -MaxSamples ([int]::MaxValue)  -Start (Get-Date).adddays(-30)  | `

where {"VMRemovedEvent" -contains $_.GetType().Name} |`

Select  @{N=”VMname”; E={$_.Vm.Name}},

    @{N=”CreatedTime”; E={$_.CreatedTime}},

    @{N=”Host”; E={$_.Host.Name}},

    @{N="Cluster";E={$_.computeResource.Name}},

    @{N=”User”; E={$_.UserName}},

        @{N=”Folder”; E={(Get-VM $_.VM.name).folder}} |sort CreatedTime|`

ConvertTo-Html -Head $a -Title "nxxx  " -Body "<H2>VMs Details </H2> " -Property VMName,Cluster, CreatedTime, Host, User, vCPU, 'Folder' |Out-File C:\xxx

somehow in above i get vmname as

%2fvmfs%2fvolumes%2f526ab7xxxx4%2fXXXX03%2fXXXX.vmx

Also the user info does not show up.

==========================================================================

i tried 1 liner as well

Get-VIEvent -maxsamples 10000 -Start (Get-Date).AddDays(-14) |where {$_.Gettype().Name-eq "VmRemovedEvent"} |Sort CreatedTime -Descending |Select CreatedTime, UserName,FullformattedMessage  

even here the user shows as User & not actual user.

Any suggestions Please

[esxi1979]

Also i tried to add below in the report but shows blank

	@{N=”vCPU”; E={(Get-VM $_.Vm.Name).numcpu }},
	@{N=”MemoryGB”; E={[Math]::Round((Get-VM $_.Vm.Name).MemoryGB)}},
	@{N=”ProvisionedSpaceGB”; E={[Math]::Round((Get-VM $_.Vm.Name).ProvisionedSpaceGB)}},
	@{N=”UsedSpaceGB”; E={[Math]::Round((Get-VM $_.Vm.Name).UsedSpaceGB)}},