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
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...
Reach out to your DB guy and ask him to run the query for you straight from the DB or leverage LogInsight.