0

I need a list of RDS DBInstanceIdentifier that match the String "foobar" in their name. I found many solutions with exact match, but not substring matching. My approach looks as follows:

I get a list of all DBInstanceIdentifier using:

aws rds describe-db-instances --query "DBInstances[*].[DBInstanceIdentifier][]" which looks like

[
    "machine-001-alice-abcdefg", 
    "machine-002-bob-abcdefg", 
    "machine-003-foobar-abcdefg"
]

On the list I apply a filter like in the last example of the JMSES Tutorial

aws rds describe-db-instances --query "DBInstances[*].[DBInstanceIdentifier][]|[?contains(@,'dev') =='true']"

If I change the statement to != I get the full list, so it seems I have the filter statement wrong.

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
supernova
  • 1,762
  • 1
  • 14
  • 31

1 Answers1

2

true needs to be backticked not quoted and then the backticks need to be escaped it seems - different shells may vary.

aws rds describe-db-instances --query "DBInstances[*].[DBInstanceIdentifier][]|[?contains(@,'dev')==\`true\`]"
aws rds describe-db-instances --query "DBInstances[*].[DBInstanceIdentifier][]|[?contains(@,'dev')!=\`true\`]"

You can also omit the comparison to true but I couldn't invert this successfully

aws --profile pollen-nonprod rds describe-db-instances --query "DBInstances[*].[DBInstanceIdentifier][]|[?contains(@,'dev')]"

(I'd normally do this sort of thing with jq but that's a different solution rather than necessarily a better one)

9bO3av5fw5
  • 882
  • 5
  • 14
  • That's exactly what I was looking for! I know jq but I need a solution that works with no dependencies. Thanks! – supernova May 17 '20 at 11:23