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 = $1;