kdhdirector
Contributor
Contributor

how to clear events in the Horizon View Administrator

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 ?

5 Replies
vcpguy
Expert
Expert

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

----------------------------------------------------------------------------- Please don't forget to reward Points for helpful hints; answers; suggestions. My blog: http://vmwaredevotee.com
0 Kudos
kdhdirector
Contributor
Contributor

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 ?

0 Kudos
vcpguy
Expert
Expert

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

----------------------------------------------------------------------------- Please don't forget to reward Points for helpful hints; answers; suggestions. My blog: http://vmwaredevotee.com
0 Kudos
JustinHVE
Contributor
Contributor

Re: Purging old events from the "historical" databases

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

0 Kudos
Gaurav_Baghla
VMware Employee
VMware Employee

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.

Regards Gaurav Baghla Opinions are my own and not the views of my employer. https://twitter.com/garry_14