Query: activedirectory_group_type

select
  'Group Type' as label,
  case
    when security_enabled then 'Security'
    else 'Microsoft 365'
  end as value
from
  azuread_group
where
  id = split_part($1, '/', 1)
  and tenant_id = split_part($1, '/', 2);