turbot/gcp_insights

Query: iam_service_account_default

Usage

powerpipe query gcp_insights.query.iam_service_account_default

SQL

select
'Project Default' as label,
case when s.email = p.default_service_account then 'Yes' else 'No' end as value
from
gcp_compute_project_metadata as p,
gcp_service_account as s
where
s.name = split_part($1, '/', 1);

Dashboards

The query is used in the dashboards: