Skip to content

Instantly share code, notes, and snippets.

View nmanzi's full-sized avatar
🌀
In a maelstrom of self indulgence.

Nathan Manzi nmanzi

🌀
In a maelstrom of self indulgence.
8 followers · 13 following
View GitHub Profile
@nmanzi
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
nmanzi / Golden Sun.html
Last active November 7, 2016 13:51 — forked from anonymous/Golden Sun.html
<!DOCTYPE html>
<html>
<head>
<style>
body {background-color: #EEE;}
.emubox {
border: 3px solid green;
padding: 10px;
}
.container{