Skip to content

Instantly share code, notes, and snippets.

@anna-anisienia

anna-anisienia/aws_config_query.sql

Created April 25, 2021 16:59
Show Gist options
  • Save anna-anisienia/d173c677f47c9711cc1f15001445f977 to your computer and use it in GitHub Desktop.
Save anna-anisienia/d173c677f47c9711cc1f15001445f977 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
aws_config_query.sql
SELECT
resourceId,
resourceType,
awsRegion,
resourceCreationTime,
tags,
configuration.state.value
WHERE
resourceType NOT IN ('AWS::EC2::SecurityGroup',
'AWS::EC2::Subnet', 'AWS::EC2::VPC',
'AWS::EC2::NetworkAcl', 'AWS::EC2::RouteTable')
ORDER BY
resourceType
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment