Event Database Tables and Schemas
Event Database Tables shows the tables that implement the event database in View.
The event database prepends the names of these tables with a prefix that you define when you set up the database. See the VMware Horizon View Installation document for more information.
Important View does not restrict the growth of the event_historical and event_data_historical tables. You must implement a space management policy for these tables.
View records details about events to all the database tables. After a certain period of time has elapsed since writing an event record, View deletes the record from the event and event_data tables. You can use View Administrator to configure the time period for which the database keeps a record in the event and event_data tables. See the VMware Horizon View Installation document for more information.
A unique primary key, EventID, identifies each event that View records in the event and event_historical tables. View records data values for each event in the event_data and event_data_historical tables. You can obtain the complete set of information for an event by joining the event and event_data tables or the event_historical and event_data_historical tables on the EventID column.
The EventType, Severity, and Time columns in the event and event_historical tables identify the type and severity of an event and the time at which it occurred.
Schema for the event and event_historical Tables shows the schema for the event and event_historical tables.
Oracle
Data Type
SQLServer
Data Type
Event name that corresponds to an item in the message catalog. For example, BROKER_USERLOGGEDIN.
View component that raised the event. For example, Admin, Broker, Tunnel, Framework, Client, or Agent.
Severity level. For example, INFO, WARNING, ERROR, AUDIT_SUCCESS, AUDIT_FAIL.
Time at which the event occurred, measured from the epoch (January 1, 1970).
Schema for the event_data and event_data_historical Tables shows the schema for the event_data and event_data_historical tables.
Oracle
Data Type
SQLServer
Data Type
Value of a string attribute. For other types of attributes, this column contains an interpretation of the data type as a string.