VMWare View Events reporting

The events reporting for VmWare view events is completely manual, based on  VMWare chooose to detach the database system from the application. I used the same DB of the VCenter.

Here some queries useful for monitoring the accesses:

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 withVEevent_historical and VEevent_data_historical respectively.

~ di diegotech su febbraio 10, 2012.

Lascia un commento

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...

 
%d blogger cliccano Mi Piace per questo: