4.6

Table Of Contents
VMware, Inc. 9
2
YoucanconfigureVMwareViewtorecordeventstoaMicrosoftSQLServerorOracledatabase.VMwareView
recordseventssuchasthefollowingexamples:
Enduseractionssuchaslogginginandstartingadesktopsession.
Administratoractionssuchasaddingentitlementsandcreatingdesktoppools.
Alertsthatreportsystemfailuresanderrors.
Statisticalsamplingsuchasrecordingthemaximumnumberofusersovera24hourperiod.
YoucanusebusinessintelligencereportingenginessuchasCrystalReports,IBMCognos,MicroStrategy9,
andOracleEnterprisePerformanceManagementSystemtoaccessandanalyzetheeventdatabase.
Thischapterincludesthefollowingtopics:
“EventDatabaseTablesandSchemas”onpage 9
“ConnectionBrokerEvents”onpage 11
“ViewAgentEvents”onpage 17
“ViewAdministratorEvents”onpage 17
“ViewTransferServerEvents”onpage 25
“EventMessageAttributes”onpage 25
“SampleDatabaseQueriesandViewsonpage 27
Event Database Tables and Schemas
Table 21showsthetablesthatimplementtheeventdatabaseinVMwareView .
Theeventdatabaseprependsthenamesofthesetableswithaprefixthatyoudefinewhenyousetupthe
database.SeetheVMwareViewInstallationdocumentformoreinformation.
Integrating with the Event Database
2
Table 2-1. Event Database Tables
Table Name Description
event Metadataandsearchoptimizationdataforrecentevents.
event_data Datavaluesforrecentevents.
event_data_historical Datavaluesforallevents.
event_historical Metadataandsearchoptimizationdataforallevents.
IMPORTANTVMwareViewdoesnotrestrictthegrowthoftheevent_historicalandevent_data_historical
tables.Youmustimplementaspacemanagementpolicyforthesetables.