turbot/steampipe-mod-gcp-insights

Query: kms_key_inventory_table

Usage

powerpipe query gcp_insights.query.kms_key_inventory_table

Steampipe Tables

SQL

select
k.name as "Name",
k.create_time as "Creation Time",
k.purpose as "Purpose",
k.key_ring_name as "Key Ring",
k.rotation_period as "Rotation Period",
k.next_rotation_time as "Next Rotation Time",
k.labels as "Labels",
p.name as "Project",
k.location as "Location"
from
gcp_kms_key as k,
gcp_project as p
where
p.project_id = k.project
order by
k.name;

Dashboards

The query is used in the dashboards: