There is currently no property for a VM that records its creation date (exception the VMs created on VCAWS in vSPhere 6.7).
The only source to find the creation date, is to scan the events on a vCenter.
But since events are only kept for a limited time (up to 1 year), you will not be able to go that far back.
On the available events you could do (mind that this script might take some time to run, depending on the number of events that are kept)
Get-VIEvent -MaxSamples ([int]::MaxValue) |
where{$_ -is [VMware.Vim.VmCreatedEvent] -or $_ -is [VMware.Vim.VmClonedEvent] -or $_ -is [VMware.Vim.VmDeployedEvent] -or $_ -is [VMware.Vim.VmRegisteredEvent]} |
Sort-Object -Property CreatedTime |
Select CreatedTime,UserName,Template,
@{N='VM';E={$_.VM.Name}},
@{N='Datacenter';E={$_.Datacenter.Name}},
@{N='VMHost';E={$_.Host.Name}},
@{N='Cluster';E={$_.ComputeResource.Name}},
@{N='Type';E={$_.GetType().Name}} |
Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture
