Integration

Table Of Contents
Integrating View with the Event
Database 2
You can configure View to record events to a Microsoft SQL Server or Oracle database. View records events
such as end-user actions, administrator actions, alerts that report system failures and errors, and statistical
sampling.
End-user actions include logging and starting desktop and application sessions. Administrator actions
include adding entitlements and creating desktop and application pools. An example of statistical sampling
is 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:
n
“Event Database Tables and Schemas,” on page 9
n
“Connection Broker Events,” on page 11
n
“View Agent Events,” on page 16
n
“View Administrator Events,” on page 17
n
“Event Message Attributes,” on page 24
n
“Sample Database Queries and Views,” on page 25
Event Database Tables and Schemas
View uses database tables to implement the event database. The event database prepends the names of these
tables with a prefix that you define when you set up the database.
Event Database Tables
The following table shows the database tables that implement the event database in View.
Table 21. 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.
VMware, Inc. 9