Query: ibm_account_table

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;