AWS Config aggregator advanced query (SQL-like syntax) SELECT statement for resources where a tag key equals a tag value

config_aggregator_sql_advanced_query.sh

# https://docs.aws.amazon.com/config/latest/developerguide/querying-AWS-resources.html
# Select EC2 instances from all accounts and regions with tag key "updateAutomationEnabled" is set to value "true"
aws configservice select-aggregate-resource-config \
  --configuration-aggregator-name org-config-aggregator \
  --expression "SELECT resourceId, resourceType, tags
                WHERE resourceType = 'AWS::EC2::Instance'
                AND tags.tag = 'updateAutomationEnabled=true'"