turbot/gcp_insights

Query: iam_service_account_enabled

Usage

powerpipe query gcp_insights.query.iam_service_account_enabled

Steampipe Tables

SQL

select
case when disabled then 'Disabled' else 'Enabled' end as value,
'Status' as label,
case when disabled then 'alert' else 'ok' end as type
from
gcp_service_account
where
name = split_part($1, '/', 1);

Dashboards

The query is used in the dashboards: