Vcenter Events

[wreedctd]

Hello,

My Vcenter is set to keep events forever, however when I run a script to show VMs built within the last 30 days, I only see VMs built today.

Any ideas?  Running 5.5

[greco827]

Can you display the contents of the script (which I assume is PowerCLI)?

Events only stay in the logs for a certain line count.  You can increase that line count, which may help, depending on how busy your environment, this may get you back 30 days (mine barely goes back 6 hours).  I'm not sure if this would affect a script or just the display in vCenter.

     In the VI Client go to Edit -->Client Settings --> Lists --> Change Page size, and increase the line count to number of lines desired .

     If necessary close and re open your VI Client.

Alternatively, if the data is no longer in the vmkernel.log, you can query the database to get older data.

Getting Previous vCenter Tasks | VMware Communities

[wreedctd]

We have 5000 VMs in this Vcenter I am trying to query.

What is another way to get what I want? Directly from SQL?

Get-VIEvent -maxsamples 0 -Start (Get-Date).AddDays(-60) | where {$_.Gettype().Name-eq "

VmCreatedEvent" -or $_.Gettype().Name-eq "VmBeingClonedEvent" -or $_.Gettype().N

ame-eq "VmBeingDeployedEvent"} |Sort CreatedTime -Descending |fl

[praveenkv]

Refer below KB, might be helpful for Logs maximum size .

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=100479...

[wreedctd]

I believe I am going to have to query the DB directly. Are there any threads on that? Do you know which table the events are in? Has anyone written a statement to do this task?