That was it! Thanks!

Sure, no problem.

# How many days in the past to start from
$start = (Get-Date).AddDays(-7)

# The more days back, the higher this number should be.
$eventNr = 9999

$report = @()

Get-VIEvent -Start $start -MaxSamples $eventNr |`
  Where-Object {$_.GetType().Name -eq "VmCreatedEvent"} | % {
     $row = "" | Select Date, User, VmName, Cluster, Host, Msg
     $row.Date = $_.createdTime
     $row.Msg = $_.fullFormattedMessage
     $row.User = $_.userName
     $row.VMName = $_.vm.name
     $t = New-Object VMware.Vim.ManagedObjectReference
     $t.type = $_.computeResource.computeResource.type
     $t.Value = $_.computeResource.computeResource.Value
     $row.Cluster = (Get-View $t).Name
     $t.type = $_.host.host.type
     $t.Value = $_.host.host.Value
     $row.Host = (Get-View $t).Name
     $report += $row
}
$report | Export-Csv "C:\VMCreated.csv" -NoTypeInformation

You run this script on a PC that has PowerCLI installed.

You connect first to your Virtual Center (with the Connect-ViServer cmdlet).

That is a well know error message.

If you uncheck the option "Check host certificates" in the VIC under , the message will still be there but the connection will succeed.

See also  VMware Infrastructure Toolkit (for Windows) *A certification chain processed correctly, but terminated in a root certificate which isn't trusted by the trust provider.

You have to save the script in a .ps1 file instead of a .bat file.

Then you can start the script from the PowerCLI prompt provided the PowerShell executionpolicy is configured correctly.

Have a look at this PowerShell Day 1 document.

I have modified Luc's script to append the csv file instead of overwriting it.

Because the Export-CSV cmdlet doesn't have an append option, I decided to import the csv file first. Then I add the new content and export the old and new content. So the file is actualy new created with the old and added content.

# How many days in the past to start from
$start = (Get-Date).AddDays(-7)

# The more days back, the higher this number should be.
$eventNr = 9999

$FileName = "C:\VMCreated.csv"
if (Test-Path $FileName) {
  $report = Import-Csv $FileName
}
else {
  $report = @()
}

Get-VIEvent -Start $start -MaxSamples $eventNr |`
  Where-Object {$_.GetType().Name -eq "VmCreatedEvent"} | % {
     $row = "" | Select Date, User, VmName, Cluster, Host, Msg
     $row.Date = $_.createdTime
     $row.Msg = $_.fullFormattedMessage
     $row.User = $_.userName
     $row.VMName = $_.vm.name
     $t = New-Object VMware.Vim.ManagedObjectReference
     $t.type = $_.computeResource.computeResource.type
     $t.Value = $_.computeResource.computeResource.Value
     $row.Cluster = (Get-View $t).Name
     $t.type = $_.host.host.type
     $t.Value = $_.host.host.Value
     $row.Host = (Get-View $t).Name
     $report += $row
}
$report | Export-Csv $FileName -NoTypeInformation

Regards, Robert

The results are stored in the CSV file. Do you mean the CSV file is empty ?

Could you perhaps attach the script so I can have a look ?

Just tested the script and it produced a CSV file with a number of VMs that were created during the last 7 days.

Are you sure you created some VMs during the last 7 days ?

How do you run the script ?