turbot/alicloud_insights

Query: kms_key_by_account

Usage

powerpipe query alicloud_insights.query.kms_key_by_account

SQL

select
a.title as "Account",
count(i.*) as "Keys"
from
alicloud_kms_key as i,
alicloud_account as a
where
a.account_id = i.account_id
group by
a.title
order by
a.title;

Dashboards

The query is used in the dashboards: