Query: sql_server_ad_authentication_status

select
  ad_authentication,
  count(*)
from (
  select
    case when server_azure_ad_administrator is null then 'disabled'
    else 'enabled'
    end ad_authentication
  from
    azure_sql_server) as s
group by
  ad_authentication
order by
  ad_authentication;