
VMware View Integration Guide
10 VMware, Inc.
VMwareViewrecordsdetailsabouteventstoallthedatabasetables.Afteracertainperiodoftimehaselapsed
sincewritinganeventrecord,VMwareViewdeletestherecordfromtheeventandevent_datatables.Youcan
useViewAdministratortoconfigurethetimeperiodforwhichthedatabasekeepsarecordintheeventand
event_datatables.SeetheVMwareVie wInstallationGuideformoreinformation.
Auniqueprimarykey,EventID,identifieseacheventthatVMwareViewrecordsintheeventandevent_
historicaltables.VMwareViewrecordsdatavaluesforeacheventintheevent_dataandevent_data_historical
tables.Youcanobtainthecompletesetofinformationforaneventbyjoiningtheeventandevent_datatables
ortheevent_historicalandevent_data_historicaltablesontheEventIDcolumn.
TheEventType,Severity,andTimecolumnsintheeventandevent_historicaltablesidentifythetypeand
severityofaneventandthetimeatwhichitoccurred.
Table 2‐2showstheschemafortheeventandevent_historicaltables.
NOTEItispossibleforeventstobelostifyourestartViewConnectionServerinstanceswhiletheevent
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) SIDoftheassociatedgroupinActive
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,
WARNING,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.