The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Search the VMware Knowledge Base (KB)
View by Article ID
Monitoring events in VMware View Manager 4.5 (1027008)
Purpose
This article provides the queries to generate reports from the EventDatabase tables of VMware View Manager 4.5.
Resolution
You can monitor events in VMware View Manager 4.5 by generating reports from the EventDatabase tables using SQL queries.
EventDatabase tables
The following table lists the various EventDatabase tables and their description:
EventDatabase table
Description
VEevent
Events recorded over the last two days
VEevent_data
Data for events recorded over the last two days
VEevent_historical
Events recorded more than two days
VEevent_data_historical
Data for events recorded more than two days
SQL queries to generate reports
To list all events triggered by a user in specific domain:
SELECT ev.EventID, ev.Time , ev.Module,ev.EventType,ev.Severity,ev.Acknowledged FROM VEevent as ev, VEevent_data as ed WHERE ev.EventID=ed.EventID AND ed.Name=’UserDisplayName’ AND ed.StrValue=’<domain\username>’
Where <domain\username> is the domain name and username of the user.
To track the Agent Shutdown events from all the virtual desktops:
SELECT ev.EventID, ev.Time, ed.StrValue FROM VEevent AS ev, VEevent_data AS ed WHERE ev.EventID = ed.EventID AND ev.EventType = ‘AGENT_SHUTDOWN’ AND ed.Name = ‘MachineName’
To list desktop failure events due to desktop pool being empty:
SELECT ev.EventID, ev.Time, ed1.StrValue, ed2.StrValue FROM VEevent AS ev, VEevent_data AS ed1, VEevent_data AS ed2 WHERE ev.EventID = ed1.EventID AND ev.EventID = ed2.EventID AND ev.EventType = ‘BROKER_POOL_EMPTY’ AND ed1.Name = ‘UserDisplayName’ AND ed2.Name = ‘DesktopID’
Note: To track the events that are more than 2 days old, replace the table names VEevent and VEevent_data with VEevent_historical and VEevent_data_historical respectively.
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.
