Query Components for AWS Config
The SQL SELECT
query components for AWS Config advanced queries are as
follows.
Synopsis
SELECT property [, ...]
[ WHERE condition ]
[ GROUP BY property ]
[ ORDER BY property [ ASC | DESC ] [, property [ ASC | DESC ] ...] ]
Parameters
- [ WHERE condition ]
-
Filters results according to the
condition
you specify.Comparison operators
-
=
(equals) -
IN
(list membership) -
BETWEEN
(range check)
Logic operators
-
AND
-
OR
-
NOT
-
- [ GROUP BY property ]
-
Aggregates the result set into groups of rows with matching values for the given property.
The GROUP BY clause is applicable to aggregations.
- [ ORDER BY property [ ASC | DESC ] [, property [ ASC | DESC ] ...] ]
-
Sorts a result set by one or more output
properties
.When the clause contains multiple properties, the result set is sorted according to the first
property
, then according to the secondproperty
for rows that have matching values for the first property, and so on.
Examples
SELECT resourceId WHERE resourceType='AWS::EC2::Instance'
SELECT configuration.complianceType, COUNT(*) WHERE resourceType = 'AWS::Config::ResourceCompliance' GROUP BY configuration.complianceType