Query: azuread_max_devices_per_user_limited

select
  tenant_id || '/' || id as resource,
  case
    when user_device_quota <= 20 then 'ok'
    else 'alarm'
  end as status,
  case
    when user_device_quota <= 20 then tenant_id || ' has maximum devices per user limited to ' || user_device_quota || ' (recommended: 20 or less).'
    else tenant_id || ' has maximum devices per user set to ' || user_device_quota || ' (recommended: 20 or less).'
  end as reason
  , tenant_id as tenant_id
from
  azuread_device_registration_policy;