Query: activedirectory_group_with_no_members_count

select
  count(*) as value,
  'Without Members' as label,
  case
    when count(*) = 0 then 'ok'
    else 'alert'
  end as type
from
  azuread_group
where
  jsonb_array_length(member_ids) = 0;