5.1

VMware, Inc. 9
2
You can configure VMware View to record events to a Microsoft SQL Server or Oracle database. VMware 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 9
 “Connection Broker Events” on page 11
 “View Agent Events” on page 17
 “View Administrator Events” on page 17
 “View Transfer Server Events” on page 25
 “Event Message Attributes” on page 25
 “Sample Database Queries and Views” on page 27
Event Database Tables and Schemas
Table 2-1 shows the tables that implement the event database in VMware 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 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 VMware 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.