Skip to content

Instantly share code, notes, and snippets.

@anna-anisienia

anna-anisienia/aws_config_query.sql

Created April 25, 2021 16:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anna-anisienia/10a51ee713654e662a4502a74b74f607 to your computer and use it in GitHub Desktop.
Save anna-anisienia/10a51ee713654e662a4502a74b74f607 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
aws_config_query.sql
SELECT
resourceId,
resourceType,
awsRegion,
resourceCreationTime,
tags,
tags.tag,
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