Query: activedirectory_group_input

select
  g.title as label,
  g.id as value,
  json_build_object(
    'tenant',
    concat('tenant: ', (split_part(g.tenant_id, '-', 5)) :: text),
    'group_id',
    concat('id: ', (split_part(g.id, '-', 5)) :: text)
  ) as tags
from
  azuread_group as g
order by
  g.title;