mortalius

Get Reservations that have more than 1 instance records and show ReservationId and InstanceIds

aws ec2 describe-instances --query 'Reservations[?Instances | length(@) > `1` ].[ReservationId,Instances[].[InstanceId]]'

Same, but shows total number of instances per Reservation

aws ec2 describe-instances \
--query 'Reservations[?Instances | length(@) == `3`].[ReservationId,Instances[] | length(@)]'

Get Name tag

mortalius

ALB

SELECT *
FROM alb_logs_UAT
WHERE parse_datetime(time,'yyyy-MM-dd''T''HH:mm:ss.SSSSSS''Z') 
     BETWEEN parse_datetime('2020-07-21-05:20:00','yyyy-MM-dd-HH:mm:ss') 
     AND parse_datetime('2020-07-21-05:45:00','yyyy-MM-dd-HH:mm:ss')
     AND elb_status_code like '4%'

mortalius

#!/bin/bash
unset AWS_PROFILE
unset AWS_DEFAULT_REGION

PROFILE=$1
REGION=$(aws --profile $PROFILE configure get region)
REGION=${REGION:-us-east-1}

echo export AWS_PROFILE=${PROFILE}
export AWS_PROFILE=${PROFILE}

mortalius

Setting branch tracking

When publishing local branch

git push -u origin dev

When checkouting

git checkout --track origin/dev

When forgot to do above