turbot/gcp_insights

Query: kms_key_by_project

Usage

powerpipe query gcp_insights.query.kms_key_by_project

Steampipe Tables

SQL

select
p.title as "Project",
count(k.*) as "total"
from
gcp_kms_key as k,
gcp_project as p
where
p.project_id = k.project
group by
p.title
order by
count(k.*) desc;

Dashboards

The query is used in the dashboards: