Skip to content

Instantly share code, notes, and snippets.

@hummus
Last active February 8, 2024 07:35
Show Gist options
  • Star 99 You must be signed in to star a gist
  • Fork 23 You must be signed in to fork a gist
  • Save hummus/8592113 to your computer and use it in GitHub Desktop.
Save hummus/8592113 to your computer and use it in GitHub Desktop.
aws cli + jq example
wget http://stedolan.github.io/jq/download/linux64/jq
aws ec2 describe-instances --filters "Name=tag:Name,Values=$NAME" \
"Name=instance-state-name,Values=running" \
| jq -r \
".Reservations[] | .Instances[] | .InstanceId" \
aws ec2 describe-volumes --filters \
"Name=status,Values=available" \
| jq -r ".Volumes[] | .VolumeId" \
aws ec2 describe-instances | jq '.Reservations[].Instances[] | select(.LaunchTime > "2015-01-28") | select(.State.Code != 48) | [.LaunchTime, .State.Name, (.Tags[]|select(.Key=="Name")|.Value)]'
# no dotdee
aws ec2 describe-instances | jq --arg yest $(python -c "import datetime; t = datetime.datetime.now() - datetime.timedelta(hours=24); print t.strftime('%Y-%m-%d')") -r '.Reservations[].Instances[] | select(.LaunchTime > $yest) | select(.State.Code != 48) | (.Tags[]//[]|select(.Key=="Name")|.Value) as $name | "Host \($name) \nHostname \(.PrivateIpAddress)"' >> ~/.ssh/config
@mdomsch
Copy link

mdomsch commented Aug 2, 2017

thanks, I found this very useful for pulling out the IP addresses of my instances!

@danpritts
Copy link

danpritts commented Oct 2, 2017

This is really helpful, thanks.

Adding this jq filter does a regex match on the "Name" tag.

| select((.Tags[]|select(.Key=="Name")|.Value) | match("REGEXHERE") )

@Tiduster
Copy link

Tiduster commented Nov 7, 2017

Thanks ! Very helpful.

@dvoita
Copy link

dvoita commented May 17, 2019

Thanks!

@rquadling
Copy link

This is really helpful, thanks.

Adding this jq filter does a regex match on the "Name" tag.

| select((.Tags[]|select(.Key=="Name")|.Value) | match("REGEXHERE") )

I found that this filter says Do I have a tag whose Key is Name and do I have a tag whose Value is regex. What it does not do is determine if the tag whose key is Name has a Value of the regex.

If you have multiple matching values, you'll get output for each value match.

@joaovitor
Copy link

joaovitor commented Mar 13, 2020

Scenario

You should not assume that all vpc has .Tags[]. I just faced the scenario below with the output of:

aws ec2 describe-vpcs > outputfile.json

Error

jq -r '.Vpcs[]|[.VpcId,.CidrBlock, (.Tags[]|select(.Key=="Name")|.Value)] | @csv' outputfile.json
jq: error (at outputfile.json:nnn): Cannot iterate over null (null)

Solution

Make Tags optional..

jq -r '.Vpcs[]|[.VpcId,.CidrBlock, (.Tags[]?|select(.Key=="Name")|.Value)] | @csv' outputfile.json

@tyaginee
Copy link

Please help me to get active Iam key of a user with create date. Thanks Neeraj

@joaovitor
Copy link

aws ec2 describe-instances | jq -r '.Reservations[]|.Instances[]|[(.Tags[]?|select(.Key=="Name")|.Value), (.Tags[]?|select(.Key=="Group-Name")|.Value),.InstanceId,.PrivateIpAddress]|@csv'|sort

@manjumaikan
Copy link

manjumaikan commented Sep 10, 2020

Scenario

You should not assume that all vpc has .Tags[]. I just faced the scenario below with the output of:

aws ec2 describe-vpcs > outputfile.json

Error

jq -r '.Vpcs[]|[.VpcId,.CidrBlock, (.Tags[]|select(.Key=="Name")|.Value)] | @csv' outputfile.json
jq: error (at outputfile.json:nnn): Cannot iterate over null (null)

Solution

Make Tags optional..

jq -r '.Vpcs[]|[.VpcId,.CidrBlock, (.Tags[]?|select(.Key=="Name")|.Value)] | @csv' outputfile.json

is there a way to assign a value to "Name" if the tag does not exist?.

For example:
aws ec2 describe-instances | jq -c '.Reservations[].Instances[] | { instanceid:.InstanceId, name:(.Tags[]? | select(.Key=="Name") | .Value)}'
will not return the instances that have tags but not the "Name" tag.

Appreciate your insights.

@kornicameister
Copy link

Found this article recently. Not sure how many examples are here and there but still it is worth linking, I believe.
https://medium.com/circuitpeople/aws-cli-with-jq-and-bash-9d54e2eabaf1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment