GetUniqueHorizonViewExternalUsers.sql

select distinct event_data.StrValue
from (select distinct event.EventID
		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.StrValue NOT LIKE '172.1%' and
    event_data.StrValue NOT LIKE '192.168.%' and
		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'