5.0
Table Of Contents
- VMware View Integration
- Contents
- Introduction
- Integrating with the Event Database
- Using View PowerCLI
- Introduction to View PowerCLI
- View PowerCLI Cmdlets
- View Administrator, View PowerCLI Cmdlet, and vdmadmin Operations
- View PowerCLI Cmdlet Parameters
- Examples of Using View PowerCLI Cmdlets
- Displaying Information About a View Connection Server Instance
- Updating the Configuration of a View Connection Server Instance
- Managing the Configuration of vCenter Servers in VMware View
- Managing Desktop Pools
- Creating and Updating Automatically Provisioned Desktop Pools
- Creating and Updating Linked-Clone Desktop Pools
- Creating and Updating Manually Provisioned Desktop Pools
- Creating Manual Unmanaged Desktop Pools
- Creating and Updating Desktops Provisioned by Terminal Servers
- Obtaining Information About Users and Groups from Active Directory
- Managing Desktop Entitlements
- Managing Local Desktops
- Managing Remote Sessions
- Managing Virtual Machines
- Displaying Information About Physical Computers
- Updating the Ownership of Machines
- Displaying Information About Events
- Managing the Global Configuration of VMware View
- Managing View Licenses
- Examples of Using View PowerCLI for Enhanced Functionality
- Customizing LDAP Data
- Integrating with SCOM
- View Management Packs
- Name a View Connection Server Group
- Import the View MPs
- View Discovery Script
- Run the Discovery Script
- Display Discovered Objects
- Display Managed Objects
- Views and Monitors
- Enable a Proxy Agent on a Server
- Display Performance Data
- Display Information About an Alert
- Restart a Service
- Exclude a Domain from Connectivity Monitoring
- Close Alerts
- Class and Relationship Definitions
- Examining PCoIP Session Statistics
- Index
VMware View Integration
10 VMware, Inc.
VMware View records details about events to all the database tables. After a certain period of time has elapsed
since writing an event record, VMware 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 View Installation document for more information.
A unique primary key, EventID, identifies each event that VMware View records in the event and event_
historical tables. VMware 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.
Table 2-2 shows the schema for the event and event_historical tables.
N
OTE It is possible for events to be lost if you restart View Connection Server instances while the event
database is not running. For a solution that avoids this problem see http://kb.vmware.com/kb/1021461.
Table 2-2. Schema for the event and event_historical Tables
Column Name
Oracle
Data Type
SQLServer
Data Type Description
Acknowledged SMALLINT tinyint Whether VMware View acknowledged the
event.
0 = false
1 = true
DesktopId NVARCHAR2(512) nvarchar(512) Desktop ID of the associated pool.
EventID INTEGER int Unique primary key for the event.
EventType NVARCHAR2(512) nvarchar(512) Event name that corresponds to an item in
the message catalog. For example,
BROKER_USERLOGGEDIN.
FolderPath NVARCHAR2(512) nvarchar(512) Full path of the folder that contains the
associated object.
GroupId NVARCHAR2(512) nvarchar(512) SID of the associated group in Active
Directory.
LUNId NVARCHAR2(512) nvarchar(512) ID of the LUN that stores the associated
object.
MachineId NVARCHAR2(512) nvarchar(512) ID of the associated physical or virtual
machine.
Module NVARCHAR2(512) nvarchar(512) View component that raised the event. For
example, Admin, Broker, Tunnel,
Framework, Client, or Agent.
ModuleAndEventText NVARCHAR2(512) nvarchar(512) Event message with values substituted for
attribute parameters.
Node NVARCHAR2(512) nvarchar(512) Name of the virtual device node.
Severity NVARCHAR2(512) nvarchar(512) Severity level. For example, INFO,
WARNING, ERROR, AUDIT_SUCCESS,
AUDIT_FAIL.
Source NVARCHAR2(512) nvarchar(512) Identifier for the source of the event.
ThinAppId NVARCHAR2(512) nvarchar(512) ID of the associated ThinApp™ object.
Time TIMESTAMP datetime Time at which the event occurred,
measured from the epoch (January 1, 1970).
UserDiskPathId NVARCHAR2(512) nvarchar(512) ID of the user disk.
UserSID NVARCHAR2(512) nvarchar(512) SID of the associated user in Active
Directory.