This generates a public/private keypair.
$ gpg --gen-key
$ gpg --list-secret-keys
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| account:DisableRegion | |
| account:EnableRegion | |
| account:ListRegions | |
| activate:CreateForm | |
| activate:GetAccountContact | |
| activate:GetContentInfo | |
| activate:GetCosts | |
| activate:GetCredits | |
| activate:GetMemberInfo | |
| activate:GetProgram |
skout23
/ logs_insights_queries.txt
Created
February 11, 2019 19:48
Scratch Pad ideas for Cloudtrail queries using AWS Cloudwatch Logs Insights
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ``` | |
| filter eventName="ConsoleLogin" | |
| | stats count(*) as eventCount by userIdentity.userName, sourceIPAddress | |
| | sort eventCount desc | |
| filter not sourceIPAddress =~ /^(?i)123.123.123.123/ and userIdentity.userName =~/^(?i)\w/ | |
| | stats count(*) as eventCount by eventName, userIdentity.userName, sourceIPAddress | |
| | sort eventCount desc | |
| filter eventName="ConsoleLogin" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| FROM alpine:3.14 | |
| ENV AWSCLI_VERSION "1.20.7" | |
| RUN apk add --update \ | |
| python3 \ | |
| python3-dev \ | |
| py-pip \ | |
| build-base \ | |
| && pip install awscli==$AWSCLI_VERSION --upgrade --user \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "fmt" | |
| "time" | |
| "github.com/aws/aws-sdk-go/aws" | |
| "github.com/aws/aws-sdk-go/aws/session" | |
| "github.com/aws/aws-sdk-go/service/athena" | |
| ) |
rgreenjr
/ postgres_queries_and_commands.sql
Last active
June 27, 2024 14:41
Useful PostgreSQL Queries and Commands
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |