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