Pinned Loading
-
Top AWS Athena queries for ALB acces...
Top AWS Athena queries for ALB access logs 1Top AWS Athena queries for ALB access logs
2Here, in one place, are some valuable queries for extracting insights and troubleshooting potential problems that I have gathered myself during my SRE experience, or found and used from the web:
34Total Requests by Day:
5SELECT
-
asciiquarium
asciiquarium PublicForked from cmatsuoka/asciiquarium
Enjoy the mysteries of the sea from the safety of your own terminal!
Perl
-
Top AWS Athena queries for Cloudtrail
Top AWS Athena queries for Cloudtrail 1-- 1. Query to Find Failed Logins
2SELECT eventTime, userIdentity.arn AS 'foo.bar', sourceIPAddress, errorCode, eventName
3FROM cloudtrail_logs
4WHERE eventName = 'ConsoleLogin'
5AND errorCode = 'FailedAuthentication'
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.