Skip to content

Instantly share code, notes, and snippets.

@RichardSilveira

RichardSilveira/AthenaVPCFlowLogQuery.sql

Created July 2, 2020 10:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RichardSilveira/322b81067f793ac1f73f02e4c27555a0 to your computer and use it in GitHub Desktop.
Save RichardSilveira/322b81067f793ac1f73f02e4c27555a0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AthenaVPCFlowLogQuery.sql
SELECT day_of_week(from_iso8601_timestamp(dt)) AS
day,
dt,
interfaceid,
sourceaddress,
destinationport,
action,
protocol
FROM vpc_flow_logs
WHERE action = 'REJECT' AND protocol = 6
order by sourceaddress
LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment