Query: activedirectory_group_members_attached_count

select
  'Attached Members' as label,
  jsonb_array_length(member_ids) as value,
  case when jsonb_array_length(member_ids) = 0 then 'alert' else 'ok' end as type
from
  azuread_group
where
  id = split_part($1, '/', 1)
  and tenant_id = split_part($1, '/', 2);