Hi internet! It’s been a while!
Thought it might be worthwhile sharing a short bit of SQL we used recently in an MFA deployment project.
The objective was to obtain a list of users that had been logging into a Horizon View 6 VDI deployment so that they could be targeted for MFA provisioning.
It appears this is quite a simple matter if the Events DB functionality is enabled. All that needs to be done is to select distinct for any ‘BROKER_USERLOGGEDIN’ entries where the ‘ClientIPAddress’ value matches something other than your internal IP ranges.
You can find the SQL to do this below. It’s been tested with Horizon 6 and 7. Enjoy!