how to clear events in the Horizon View Administrator

[kdhdirector]

I would like to clear the events/alerts in the Horizon View Administrator.

I do not want to wait until a timeout or scheduled purge.

How can I do this ?

[vcpguy]

AFAIK out of the box you cannot remove those events it stays in the database. May be some hack or some SQL cmds to delete those data inside the table

[kdhdirector]

I'm ok with doing whatever in SQL, but I'd love to hear from VMWare as to what's proper - and why is there no clear button ?

[vcpguy]

A feature request is the "need of hour" - Contact VMware | United States

[JustinHVE]

Re: Purging old events from the "historical" databases

I posted a sql query on that years ago that could help you with this situation.

[Gaurav_Baghla]

View Events Database is different from Composer and Vcenter where Composer and Vcenter useful information but Events database have information for logon login disconnects it is safe to create a new Databaseas well for that.

There are 5 tables in the View_Events database

1. 1. dbo.event
2. 2. dbo.event_data
3. 3. dbo.Event_data_historical
4. 4. dbo.event_historical
5. 5. dbo.props

Those tables are separated into "current", "historical" and "Configuration" data.

Current:

--------

1. 1. dbo.event
2. 2. dbo.event_data

Historical:

-----------

1. 3. dbo.Event_data_historical
2. 4. dbo.event_historical

Configuration:

--------------

1. 5. dbo.props

This table is currently just responsible for versioning.

1. dbo.props  has two fields; Name and Value

The contents are:

Name    Value

write_compatibility 4.5

schema_version  4.5

We can set the time period for which the events are stored in the events table that would be from admin Page

You can delete everything from the Historical Table using the Commands below

delete from dbo.event_data_historical

delete from dbo.event_historical

Be very careful when deleting records. You cannot undo this statement!

Hopefully that helps.