AWS CLI --query to select tag by value

Question

There were a lot of topics about this, but I still have a problem with a query.

I used:

aws rds list-tags-for-resource --resource-name arn:aws:rds:eu-west-:xxxxx --query 'TagList[*]'

Output:

{

    "Value": "test@test",
    "Key": "Owner"
},
{
    "Value": "XXXX",
    "Key": "Schedule"
}   

I need to display only XXXX value. I tried:

aws rds list-tags-for-resource --resource-name arn:aws:rds:eu-west-1:xxxxx --query 'TagList[].Tags[?Key==`Schedule`].Value[]' --output text

but it does not work.

Answer 1

Give a try to this:

aws rds list-tags-for-resource --resource-name arn:aws:rds:eu-west-:xxxxx --query "TagList[?Key=='Schedule'].Value[]"

Also, you may want to use jq:

aws rds list-tags-for-resource --resource-name arn:aws:rds: | jq ".TagList[].Value"

Answer 2

You do not have a nested Tags key inside the TagList list. Filter at the same level:

aws rds list-tags-for-resource \
--resource-name your:arn \
--query 'TagList[?Key==`Schedule`]'