Nathan Manzi nmanzi

🌀

In a maelstrom of self indulgence.

IT Ops Manager, InfoSec goon, and all-round nerd.

nmanzi / GetUniqueHorizonViewExternalUsers.sql

Created June 14, 2017 09:56 — forked from anonymous/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

nmanzi / Golden Sun.html

Last active November 7, 2016 13:51 — forked from anonymous/Golden Sun.html