Database Query for Horizon Historical Data

[bvi1006]

Hi, I have been asked to get historical data on average session times per day. Does anyone know where this data might be in the database and how to extract it? 

Thanks!

[Mickeybyte]

@bvi1006 

Some details about the tables can be found here: Event Database Tables and Schemas (vmware.com)

For the information you are looking for, you might want to check the column EventType for the values "AGENT_CONNECTED", "AGENT_DISCONNECTED", "AGENT_RECONNECTED" and "AGENT_ENDED" and calculate the times between those events.

Below you can see a logon, disconnect, reconnect and logoff sequence in the event table: 

You will of course need some additional logic to group those events per user and per desktop to calculate the average session time, but it's a starting point.

[bvi1006]

Thanks Mickeybyte, I will look at this...