turbot/gcp_insights

Query: iam_storage_account_overview

Usage

powerpipe query gcp_insights.query.iam_storage_account_overview

Steampipe Tables

SQL

select
display_name as "Name",
oauth2_client_id as "OAuth 2.0 client ID",
unique_id as "ID",
email as "Email ID",
title as "Title",
location as "Location",
project as "Project"
from
gcp_service_account
where
name = split_part($1, '/', 1);

Dashboards

The query is used in the dashboards: