Query: sql_server_azure_ad_authentication_disabled_count

select
  count(*) as value,
  'Azure AD Authentication Disabled' as label,
  case count(*) when 0 then 'ok' else 'alert' end as type
from
 azure_sql_server
where
  server_azure_ad_administrator is null;