Skip to content

Instantly share code, notes, and snippets.

@Mikulas

Mikulas/aws-vpc-flow-log-internal-costly-traffic.sql

Last active July 28, 2017 08:05
Show Gist options
  • Save Mikulas/b845b3318cd8d43480b6e256af912043 to your computer and use it in GitHub Desktop.
Save Mikulas/b845b3318cd8d43480b6e256af912043 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
aws-vpc-flow-log-internal-costly-traffic.sql
SELECT dstaddr, sum(bytes)
FROM vpc
WHERE crosszone=1
AND external=0
GROUP BY dstaddr
ORDER BY 2 desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment