turbot/steampipe-mod-gcp-insights

Query: iam_service_account_inventory_table

Usage

powerpipe query gcp_insights.query.iam_service_account_inventory_table

SQL

select
sa.name as "Name",
sa.display_name as "Display Name",
sa.description as "Description",
sa.email as "Email",
sa.disabled as "Disabled",
sa.oauth2_client_id as "OAuth2 Client ID",
sa.unique_id as "Unique ID",
p.name as "Project",
sa.location as "Location"
from
gcp_service_account as sa,
gcp_project as p
where
p.project_id = sa.project
order by
sa.name;

Dashboards

The query is used in the dashboards: