Control: RDS DB instances should be deployed in a VPC
Description
This control checks whether RDS DB instances are deployed in a VPC.
Usage
Run the control in your terminal:
powerpipe control run aws_perimeter.control.rds_db_instance_in_vpc
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_perimeter.control.rds_db_instance_in_vpc --share
Steampipe Tables
SQL
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 || ' not in VPC.' else title || ' in VPC ' || vpc_id || '.' end as reason , region, account_idfrom aws_rds_db_instance;