turbot/aws_insights

Query: ebs_volume_encryption_status

Usage

powerpipe query aws_insights.query.ebs_volume_encryption_status

Steampipe Tables

SQL

select
case when encrypted then 'Enabled' else 'Disabled' end as "Encryption",
kms_key_id as "KMS Key ID"
from
aws_ebs_volume
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: