VMware Horizon Community
Germasn
Contributor
Contributor

Query Event DB to find who has connected to a pool over a certain period of time

Hi all,

I need to get a list of users that have connected to a certain pool over the last 2 weeks in Horizon.

I have tried to query the db with little success as my SQL is rubbish. Any help appreciated.

Tags (2)
Reply
0 Kudos
3 Replies
rchave
Contributor
Contributor

The easiest way is to use the Horizon toolbox fling if SQL is not your thing, but you can query the "event_historical table" Select * FROM [YOURTABLE] WHERE [TIME] > 'YOURDATE' AND EventType = 'BROKER_USERLOGGEDIN'

Thanks,

Rodmy

Reply
0 Kudos
Germasn
Contributor
Contributor

Thanks Rodmy, I'll give it a go.

The fling won't work. When I connect to the historical DB gives me an error:

Error Connecting to SQL DB: - Please check connectivity. The connection was not closed. The connection's current state is open.

As soon as I untick the Query Historical Data it connects fine...

Reply
0 Kudos
cbaptiste
Hot Shot
Hot Shot

Reach out to your DB guy and ask him to run the query for you straight from the DB or leverage LogInsight.

Reply
0 Kudos