turbot/gcp_insights

Query: compute_disk_encryption_table

Usage

powerpipe query gcp_insights.query.compute_disk_encryption_table

SQL

select
d.name as "Name",
d.id::text as "ID",
case
when disk_encryption_key_type = 'Google managed' then 'Google Managed'
when disk_encryption_key_type = 'Customer managed' then 'Customer Managed'
else 'Customer Supplied'
end as "Encryption Type",
d.disk_encryption_key ->> 'kmsKeyName' as "KMS Key",
p.name as "Project",
p.project_id as "Project ID",
d.location as "Location",
d.self_link as "Self-Link"
from
gcp_compute_disk as d,
gcp_project as p
where
p.project_id = d.project
order by
d.name;

Dashboards

The query is used in the dashboards: