The earlier suggestion with snowflake.organization_usage.accounts should work.
snowflake.organization_usage.accounts
select * from snowflake.organization_usage.accounts where account_name = '<NAME>';