4.6
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
- Index
VMware View Integration
10 VMware, Inc.
VMwareViewrecordsdetailsabouteventstoallthedatabasetables.Afteracertainperiodoftimehaselapsed
sincewritinganeventrecord,VMwareViewdeletestherecordfromtheeventandevent_datatables.Youcan
useViewAdministratortoconfigurethetimeperiodforwhichthedatabasekeepsa
recordintheeventand
event_datatables.SeetheVMwareView Installationdocumentformoreinformation.
Auniqueprimarykey,EventID,identifieseacheventthatVMwareViewrecordsintheeventandevent_
historicaltables.VMwareViewrecordsdatavaluesforeacheventintheevent_dataandevent_data_historical
tables.Youcan
obtainthecompletesetofinformationforanev entbyjoiningtheeventandevent_datatables
ortheevent_historicalandevent_data_historicaltablesontheEventIDcolumn.
TheEventType,Severity,andTimecolumnsintheeventandevent_historicaltablesidentifythetypeand
severityofaneventandthetimeatwhich
itoccurred.
Table 2‐2showstheschemafortheeventandevent_historicaltables.
N
OTEItispossibleforeventstobelostifyourestartViewConnectionServerinstanceswhiletheevent
databaseisnotrunning.Forasolutionthatavoidsthisproblemseehttp://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 WhetherVMwareViewacknowledgedthe
event.
0=false
1=true
DesktopId NVARCHAR2(512) nvarchar(512) DesktopIDoftheassociatedpool.
EventID INTEGER int Uniqueprimarykeyfortheevent.
EventType NVARCHAR2(512) nvarchar(512) Eventnamethatcorrespondstoanitemin
themessagecatalog.Forexample,
BROKER_USERLOGGEDIN.
FolderPath NVARCHAR2(512) nvarchar(512) Fullpathofthefolderthatcontainsthe
associatedobject.
GroupId NVARCHAR2(512) nvarchar(512) SIDofthe
associatedgroupinActive
Directory.
LUNId NVARCHAR2(512) nvarchar(512) IDoftheLUNthatstorestheassociated
object.
MachineId NVARCHAR2(512) nvarchar(512) IDoftheassociatedphysicalorvirtual
machine.
Module NVARCHAR2(512) nvarchar(512) Viewcomponentthatraisedtheevent.For
example,Admin,Broker,Tunnel,
Framework,Client,orAgent.
ModuleAndEventText NVARCHAR2(512) nvarchar(512) Eventmessagewithvaluessubstitutedfor
attributeparameters.
Node NVARCHAR2(512) nvarchar(512) Nameofthevirtualdevicenode.
Severity NVARCHAR2(512) nvarchar(512) Severitylevel.
Forexample,INFO,
WARNIN G,ERROR,AUDIT_SUCCESS,
AUDIT_FAIL.
Source NVARCHAR2(512) nvarchar(512) Identifierforthesourceoftheevent.
ThinAppId NVARCHAR2(512) nvarchar(512) IDoftheassociatedThinApp™object.
Time TIMESTAMP datetime Timeatwhichtheeventoccurred,
measuredfromtheepoch(January1,1970).
UserDiskPathId NVARCHAR2(512) nvarchar(512) IDoftheuserdisk.
UserSID NVARCHAR2(512) nvarchar(512) SIDoftheassociateduserinActive
Directory.