Query: cosmosdb_account_public_status

select
  public_network,
  count(*) as accounts
from (
  select
    case when public_network_access = 'Enabled' then 'public'
    else 'private'
    end public_network
  from
    azure_cosmosdb_account) as s
group by
  public_network
order by
  public_network;