turbot/gcp_insights

Query: iam_storage_account_keys

Usage

powerpipe query gcp_insights.query.iam_storage_account_keys

SQL

select
k.name as "Name",
k.key_origin as "Origin",
k.key_type as "Type",
k.key_algorithm as "Algorithm"
from
gcp_service_account_key as k,
gcp_service_account as s
where
s.email = k.service_account_name
and s.name = split_part($1, '/', 1);

Dashboards

The query is used in the dashboards: