turbot/aws_insights

Query: rds_db_instances_for_kms_key

Usage

powerpipe query aws_insights.query.rds_db_instances_for_kms_key

Steampipe Tables

SQL

select
arn as db_instance_arn
from
aws_rds_db_instance as i
where
i.kms_key_id = $1
and i.region = split_part($1, ':', 4)
and i.account_id = split_part($1, ':', 5);