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 = $1;

Dashboards

The query is used in the dashboards: