in Scripts, Sysadmin, VDI, VMware

Finding External Users in Horizon View

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!