Query: sql_server_ad_authentication_enabled

select
  'Azure AD Authentication' as label,
  case
    when server_azure_ad_administrator is not null then 'Enabled'
    else 'Disabled'
  end as value,
  case
    when server_azure_ad_administrator is not null then 'ok'
    else 'alert'
  end as type
from
  azure_sql_server
where
  lower(id) = $1;