Control: RDS instances should be deployed in a VPC
Description
This control checks whether an RDS instance is deployed in a VPC (EC2-VPC).
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.rds_db_instance_in_vpc
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.rds_db_instance_in_vpc --share
SQL
This control uses a named query:
select arn as resource, case when vpc_id is null then 'alarm' else 'ok' end as status, case when vpc_id is null then title || ' is not in VPC.' else title || ' is in VPC ' || vpc_id || '.' end as reason , region, account_idfrom aws_rds_db_instance;