AWS CLI JMESPath Cheatsheet

aws_jmespath_cheatsheet.md

List all SNS topics

aws sns list-topics --query 'Topics[*]' --output text | cut -d ':' -f 6

List all buckets

aws s3 ls | cut -d ' ' -f 3

List all Cloudwatch Alarms

aws cloudwatch describe-alarms \ 
   --query 'MetricAlarms[*].{arn:AlarmArn, name:AlarmName,threshold:Threshold, statistic:Statistic, state:StateValue}'

List EC2 networking configuration

aws ec2 describe-instances \
   --filters "Name=instance-state-name,Values=running" \
   --query="Reservations[*].Instances[*].{instance_id: InstanceId, vpc_id: VpcId, availaiblity_zone: Placement.AvailabilityZone, instance_type: InstanceType, subnet_id: SubnetId}" \
   --output=text

List DNS Records sets in hosted zone

aws route53 list-resource-record-sets --hosted-zone-id={ZoneID}

List SQS

aws sqs list-queues --query 'QueueUrls[*]' --output text | tr '\t' '\n' | cut -d '/' -f 5