LucD,
Thanks for that link! I was able to use it for my needs and it worked great, but as in most of life, there was an issue when I tried to expand the script a little bit.
Below is an excerpt from the script:
Get-VIEvent -Start $start -MaxSamples $eventNr |`
Where-Object {$_.GetType().Name -eq "VmCreatedEvent" -or $_.Gettype().Name-eq "VmBeingDeployedEvent"} | % {
$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
When I run just this portion, it works great: I get a list of VM's created during the time period specified, along with who created them and when they were created. The reason this isnt sufficient though is because the script results also include VDI virtual desktop creation events, which I do NOT want in the report. Then I noticed that the $row.VMName variable was fed $_.vm.name, which would be the VM name of the current object being processed. So, I figured a filter at the end of the script could kick those virtual desktops out of the report. When I tried to grab that variable and insert it into another line like this:
if ($row.VMName -inotlike "xvm*") {
Get-VM -Name $row.VMName | Select-Object "Name",{$_.Guest.OSFullName},{$_.MemoryMB},{$_.HardDisks.Length},{$_.NumCPU} | ft -AutoSize}
the script craps out with errors that dont really give me a sense of what the issue really is.
Here is the error reported:
"+ function PipelineBreakpointerE4078E3092DF4dd9A469F3DC0CBB505C( $offset){BEGIN {} PROCESS {$host.SetShouldExit($offset); $_} <<<< END {}};$vE4078E3092DF4dd9A469F3DC0CBB505C={Remove-PSBreakPoint -BreakPoint $bE4078E3092DF4dd9A469F3DC0CBB505C;Remove-Variable vE4078E3092DF4dd9A469F3DC0CBB505C;Remove-Variable bE4078E3092DF4dd9A469F3DC0CBB505C;
The pipeline has been stopped.
At :line:28 char:2
+ <<<< Get-VM -Name $row.VMName | Select-Object "Name",{$_.Guest.OSFullName},{$_.MemoryMB},{$_.HardDisks.Length},{$_.NumCPU} | ft -AutoSize}
Operation is not valid due to the current state of the object.
At :line:0 char:0"
