bvi1006
Enthusiast
Enthusiast

Database Query for Horizon Historical Data

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!

0 Kudos
2 Replies
Mickeybyte
Hot Shot
Hot Shot

@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: 

Mickeybyte_0-1634042843774.png

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.

Regards,
Mickeybyte

If you found this comment useful or an answer to your question, please mark as 'Solved' and/or click the 'Kudos' button, please ask follow-up questions if you have any
Tags (2)
bvi1006
Enthusiast
Enthusiast

Thanks Mickeybyte, I will look at this...

0 Kudos