Uly.me

cloud engineer

  • Home
  • About
  • Archives
Home/Archives for query

January 2, 2021

AWS CLI Display Tags

This command lists the EC2 instance id and the tag name using query.

aws ec2 describe-instances \
--query 'Reservations[].Instances[].[InstanceId,Tags[?Key==Name]|[0].Value]' \
--profile tfc \
--region us-east-2 \
--output text

aws ec2 describe-instances \ --query 'Reservations[].Instances[].[InstanceId,Tags[?Key==Name]|[0].Value]' \ --profile tfc \ --region us-east-2 \ --output text

Output:

i-xxxxxxxxxxxxxxxxx     server-one
i-xxxxxxxxxxxxxxxxx     server-two
i-xxxxxxxxxxxxxxxxx     server-three

i-xxxxxxxxxxxxxxxxx server-one i-xxxxxxxxxxxxxxxxx server-two i-xxxxxxxxxxxxxxxxx server-three

|[0].Value insures output is one instance record per line.

November 11, 2020

AWS CLI Using Query

Instead of using AWS and JQ to get the snapshot names, you can do it with a single command using –query.

Here are the previous commands.

/usr/bin/aws lightsail get-instance-snapshots --region us-east-1 --profile default > $snaps
cat $snaps | jq -r '.instanceSnapshots[] | .name' > $names

/usr/bin/aws lightsail get-instance-snapshots --region us-east-1 --profile default > $snaps cat $snaps | jq -r '.instanceSnapshots[] | .name' > $names

Using query.

aws lightsail get-instance-snapshots \
--query 'instanceSnapshots[*].[name]' \
--region us-east-1 \
--profile default \
--output text > $names

aws lightsail get-instance-snapshots \ --query 'instanceSnapshots[*].[name]' \ --region us-east-1 \ --profile default \ --output text > $names

July 17, 2019

AWS CLI EC2 Instance Status

How to display AWS EC2 instance statuses.

aws ec2 describe-instance-status \
--query 'InstanceStatuses[].[InstanceId,SystemStatus.Status]' \
--include-all-instances \
--region us-east-2
--profile abcdef \

aws ec2 describe-instance-status \ --query 'InstanceStatuses[].[InstanceId,SystemStatus.Status]' \ --include-all-instances \ --region us-east-2 --profile abcdef \

Query and Filter.

aws ec2 describe-instance-status \
--query 'InstanceStatuses[].[InstanceId,SystemStatus.Status]' \
--filter 'Name=instance-state-name,Values=stopped' \
--region us-east-2
--profile abcdef \

aws ec2 describe-instance-status \ --query 'InstanceStatuses[].[InstanceId,SystemStatus.Status]' \ --filter 'Name=instance-state-name,Values=stopped' \ --region us-east-2 --profile abcdef \

Filter event.code equal to instance-reboot.

aws ec2 describe-instance-status \
--query 'InstanceStatuses[].[InstanceId,SystemStatus.Status]' \
--filter 'Name=eventcode,Values=instance-reboot' \
--region us-east-2
--profile abcdef \

aws ec2 describe-instance-status \ --query 'InstanceStatuses[].[InstanceId,SystemStatus.Status]' \ --filter 'Name=eventcode,Values=instance-reboot' \ --region us-east-2 --profile abcdef \

  • 1
  • 2
  • Next Page »
  • Cloud
  • Linux
  • Git

Copyright © 2012–2021