Skip to content

Instantly share code, notes, and snippets.

@RichardSilveira
Created July 2, 2020 10:43
Show Gist options
  • Save RichardSilveira/322b81067f793ac1f73f02e4c27555a0 to your computer and use it in GitHub Desktop.
Save RichardSilveira/322b81067f793ac1f73f02e4c27555a0 to your computer and use it in GitHub Desktop.
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