Query: activedirectory_group_overview

select
  display_name as "Display Name",
  created_date_time as "Create Time",
  visibility as "Visibility",
  expiration_date_time as "Expiration Time",
  case when is_assignable_to_role then is_assignable_to_role else 'false' end as "Is Assignable To Role",
  mail_enabled as "Mail Enabled",
  tenant_id as "Tenant ID",
  id as "ID"
from
  azuread_group
where
  id = split_part($1, '/', 1)
  and tenant_id = split_part($1, '/', 2);