turbot/gcp_insights

Query: kms_key_rotation_period

Usage

powerpipe query gcp_insights.query.kms_key_rotation_period

Steampipe Tables

SQL

select
'Rotation Period in days' as label,
nullif(split_part(rotation_period, 's', 1), '')::int / ( 60 * 60 * 24) as value
from
gcp_kms_key
where
self_link = $1;

Dashboards

The query is used in the dashboards: