5.2

VMware, Inc. 11
2w
You can configure VMware Horizon View to record events to a Microsoft SQL Server or Oracle database. View
records events such as the following examples:
 End-user actions such as logging in and starting a desktop session.
 Administrator actions such as adding entitlements and creating desktop pools.
 Alerts that report system failures and errors.
 Statistical sampling such as recording the maximum number of users over a 24-hour period.
You can use business intelligence reporting engines such as Crystal Reports, IBM Cognos, MicroStrategy 9,
and Oracle Enterprise Performance Management System to access and analyze the event database.
This chapter includes the following topics:
 “Event Database Tables and Schemas” on page 11
 “Connection Broker Events” on page 13
 “View Agent Events” on page 19
 “View Administrator Events” on page 19
 “View Transfer Server Events” on page 27
 “Event Message Attributes” on page 27
 “Sample Database Queries and Views” on page 29
Event Database Tables and Schemas
Table 2-1 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.
Integrating with the Event Database
2
Table 2-1. Event Database Tables
Table Name Description
event Metadata and search optimization data for recent events.
event_data Data values for recent events.
event_data_historical Data values for all events.
event_historical Metadata and search optimization data for all events.
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.