Queries the Horizon View Events DB for unique users logging into a broker from outside of local networks.

GetUniqueHorizonViewExternalUsers.sql

select distinct event_data.StrValue
from (select distinct event.EventID, event_data.StrValue
  from event inner join viewevents.dbo.event_data
  on event_data.EventID = ViewEvents.dbo.event.EventID 
  where EventType = 'BROKER_USERLOGGEDIN' and 
  Time >= '2017-05-01' and 
  event_data.StrValue NOT LIKE '10.%' 
  and event_data.Name = 'ClientIPAddress') t inner join ViewEvents.dbo.event_data on t.EventID = ViewEvents.dbo.event_data.EventID
where event_data.Name = 'UserDisplayName'