turbot/ibm_insights

Query: ibm_account_table

Usage

powerpipe query ibm_insights.query.ibm_account_table

SQL

select
a.name as "Name",
a.customer_id as "Customer ID",
a.owner_user_id as "Owner User ID",
a.owner_unique_id as "Owner Unique ID",
a.organizations as "Organizations",
s.mfa as "MFA",
a.state as "State",
a.type as "Type"
from
ibm_account as a
left join ibm_iam_account_settings s on a.customer_id = s.account_id
order by
a.name;

Dashboards

The query is used in the dashboards: