Integration

VMware, Inc. 13
Chapter 2 Integrating with the Event Database
Table 2-3 shows the schema for the event_data and event_data_historical tables.
Connection Broker Events
Table 2-4 shows the event types for the connection broker.
The BROKER_DAILY_MAX_DESKTOP_SESSIONS event reports the maximum number of concurrent
desktop sessions over a 24-hour period. If a user runs multiple desktop sessions concurrently, each desktop
session is counted separately. The BROKER_DAILY_MAX_APP_USERS event reports the maximum number
of concurrent application users over a 24-hour period. If a user runs multiple applications concurrently, the
user is counted only once. Short-lived sessions might not be included in the count because the sampling is
performed every five minutes.
The BROKER_VC_DISABLED and BROKER_VC_ENABLED events report the state of of the vCenter driver
that View uses to track a vCenter Server. The BROKER_VC_STATUS_* events report the state of a vCenter
Server.
Table 2-3. Schema for the event_data and event_data_historical Tables
Column Name
Oracle
Data Type
SQLServer
Data Type Description
BooleanValue SMALLINT tinyint Value of a Boolean attribute.
0 = false
1 = true
EventID INTEGER int Unique primary key for the event.
IntValue INTEGER int Value of an integer attribute.
Name NVARCHAR2(512) nvarchar(512) Attribute name (for example,
UserDisplayName).
StrValue NVARCHAR2(512) nvarchar(512) Value of a string attribute. For other types
of attributes, this column contains an
interpretation of the data type as a string.
TimeValue TIMESTAMP datetime Value of a date and time attribute.
Type SMALLINT tinyint The data type of the attribute.
0 = StrValue
1 = IntValue
2 = TimeValue
3 = BooleanValue
Table 2-4. Connection Broker Events
EventType Severity ModuleAndEventText
BROKER_AGENT_OFFLINE WARNING The agent running on machine
${MachineName} has not responded to
queries, marking it as offline
BROKER_AGENT_ONLINE WARNING The agent running on machine
${MachineName} is responding again, but
did not send a startup message
BROKER_APPLICATION_LAUNCH_FAILURE ERROR Unable to launch from Pool ${PoolId} for
user ${UserDisplayName}: The broker
encountered an error while processing the
request, please contact support for
assistance.
BROKER_APPLICATION_MISSING WARNING At least ${ApplicationMissingCount}
applications, including
${ApplicationExecutable}, are not installed
on ${MachineName} in Pool ${PoolId}