turbot/aws_insights

Query: ebs_volumes_for_kms_key

Usage

powerpipe query aws_insights.query.ebs_volumes_for_kms_key

Steampipe Tables

SQL

select
v.arn as volume_arn
from
aws_ebs_volume as v
where
v.kms_key_id = $1
and v.region = split_part($1, ':', 4)
and v.account_id = split_part($1, ':', 5);