The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Monitoring events in VMware View Manager 4.5 (1027008)
You can monitor events in VMware View Manager 4.5 by generating reports from the EventDatabase tables using SQL queries.
The following table lists the various EventDatabase tables and their 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|
|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.