Count of VMs Created and Deleted in One week

[Pilu1978]

Hi,

I want to have a powercli script which will give me the count of VMs created and deleted last week in a cluster.

Please help.

[LucD]

You can use the Get-VIEvent cmdlet and look for the specific events.

This is an example in it's simplest form.

$entity = Get-Cluster MyCluster
$start = (Get-Date).AddDays(-7)
$eventTypes = "VmCreatedEvent","VmRemovedEvent"
 Get-VIEvent -Start $start |
 where {$eventTypes -contains $_.GetType().Name} | 
Group-Object -Property {$_.GetType().Name} | %{
  New-Object PSObject -Property @{
    Type = $_.Values[0]
    Number = $_.Group.Count
  }
}

[Pilu1978]

Hi LucD,

Thanks for your reply.

There is no output when I as providing -Entity as my Cluster name. But when I am doing $vms = $clustername | Get-vm and mentioning the $vms as entity then the script is showing output. Is there any reason for that. Also when I am mentioning $vms as entity it is taking hell lot of time to retrieve the information. Please find the command which I am running below:

Get-ViEvent -Entity $vms -maxsamples 10000 -Start (Get-Date).AddDays(-7) -Finish (Get-Date) | where {$_.Gettype().Name -eq "vmCreatedEvent"}

[LucD]

Which PowerCLI version are you using ?

Do a

Get-PowerCLIVersion

For me this works with PowerCLI 5.0.1 against a vCenter 5.x with only the Get-Cluster for the entity.

The Get-VIEvent cmdlet becomes slower depending on the number of objects you pass via the Entity parameter.

I notice a that it runs twice as long when I do 'Get-Cluster MyCluster | Get-VM'

[Pilu1978]

Hi LucD,

I am running 5.0.1 version of powercli on Vsphere 4.1.

Whenever I am giving 'Get-Cluster My Cluster' as entity it is not returning any value. But when I am giving 'Get-Cluster MyCluster | Get-VM' it is showing the VMs created last week but it is taking long time retrive the info.

So does it mean Get-ViEvent is unable to retrive the information when entity is given as cluster.

[LucD]

This might perhaps be related to the vSPhere version you are using.

With vSphere 5.x it seems to work for me.