VMware Horizon Community
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!

Reply
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 (ITPro blog)

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...

Reply
0 Kudos