• Skip to main content

Uly.me

cloud engineer

  • Home
  • About
  • Search

query

AWS CLI Display Tags

January 2, 2021

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.

Filed Under: Cloud Tagged With: aws, describe-instances, ec2, instance-id, query, tags

AWS CLI Using Query

November 11, 2020

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

Filed Under: Cloud Tagged With: aws cli, lightsail, query, snapshots

AWS CLI EC2 Instance Status

July 17, 2019

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 \

Filed Under: Cloud Tagged With: aws, describe-instance-status, ec2, filter, query

AWS CLI: Describe Instances

December 13, 2018

If you have a ton of EC2 instances, one way to get results quickly is to run to use AWS CLI such as “describe-instances.” Here’s an example on how to get a list of instances with a tag name equal to some value. In addition, you limit the display only results you want displayed.

$ aws ec2 describe-instances \
--query 'Reservations[].Instances[].Tags[?Key==`Name`].Value' \
--filter Name=tag:Project,Values=web \
--region us-east-1 \
--profile default \
--output text

$ aws ec2 describe-instances \ --query 'Reservations[].Instances[].Tags[?Key==`Name`].Value' \ --filter Name=tag:Project,Values=web \ --region us-east-1 \ --profile default \ --output text

This returns values of the “Name” tag name in instances where they occur.

Filed Under: Cloud Tagged With: aws cli, describe instances, ec2, filter, query, tags

  • Home
  • About
  • Search

Copyright © 2023