Parsing AWS JSON with JQ

Question

I'm trying to parse JSON output from the AWS CLI. What I'm looking for are security group names with specific tags below them. The two commands that work are

$aws ec2 describe-security-groups | jq  -r '.SecurityGroups[].GroupName'
default
mysqlsg
apachesg
default

Then I run

$ aws ec2 describe-security-groups | jq  -r '.SecurityGroups[].Tags[]|select(.Key == "Service")'
{
  "Key": "Service",
  "Value": "default"
}
{
  "Key": "Service",
  "Value": "MySQL"
}
{
  "Key": "Service",
  "Value": "Apache"
}
{
  "Key": "Service",
  "Value": "default"
}

I'd like each group to have the Service Tag below it so I tried this but it didn't work.

$ aws ec2 describe-security-groups | jq  -r '.SecurityGroups[].GroupName,.SecurityGroups[].Tags[]|select(.Key == "Service")'
jq: error (at <stdin>:225): Cannot index string with string "Key"

what do you mean by "I'd like each group to have the Service Tag"> — Adiii
– Adiii, Commented Jul 17, 2020 at 12:36
Each security group has the tag with Key Service. I'd like to display the Group Name with the Tags that have Key Service and it's value below it. — Matthew Wimpelberg
– Matthew Wimpelberg, Commented Jul 17, 2020 at 12:45

Adiii · Accepted Answer · 2020-07-17 12:53:31Z

1

You can do this with aws-cli query parameters, try the below and it should work.

aws ec2 describe-security-groups --query 'SecurityGroups[].{Tags:Tags[?Key==`Name`].Value|[0],GroupName:GroupName}'

output

    {
        "Tags": "demo",
        "GroupName": "demo"
    }

answered Jul 17, 2020 at 12:53

Adiii

61.1k10 gold badges180 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing AWS JSON with JQ

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related