Query: ad_require_mfa_for_device_join

with distinct_tenant as (
  select
    distinct tenant_id,
    display_name,
    subscription_id,
    _ctx
  from
    azure_tenant
)
select
  id as resource,
  case
    when multi_factor_auth_configuration = 'required' then 'ok'
    else 'alarm'
  end as status,
  case
    when multi_factor_auth_configuration = 'required' then t.display_name || ' MFA is required for device registration.'
    else
      t.display_name || ' MFA is not required for device registration.'
  end as reason,
  t.tenant_id
  
from
  distinct_tenant as t,
  azuread_device_registration_policy;