The ADGroup table contains all the Active Directory groups for the tenant.

Column

Type

Description

ObjectGUID

String

Group's UUID (primary key).

Name

String

Group's name.

SamAccountName

String

Group's Sam Account name.

DistinguishedName

String

Group's distinguished name.

Example Query

The following example queries the DistinguishedName column from the ADGroup table.

{
Script: "Select DistinguishedName from ADGroup 
    WHERE Name LIKE '%test%' 
    ORDER BY Name COLLATE NOCASE"
}

The query returns entries that have the letters 'test' in the AD group name.

ADGroup table query response:

{
...
"FullCount": 4,
"Results": [
  {
    "Entities": [],
    "Row": {
      "DistinguishedName": "CN=BoxTest,OU=Groups - Security,DC=idaptive,DC=com"
    }
  },
  {
    "Entities": [],
    "Row": {
      "DistinguishedName": "CN=idaptive,OU=Groups - Security,DC=idaptive,DC=com"
    }
  },
  {
    "Entities": [],
    "Row": {
      "DistinguishedName": "CN=cloudsupporttest,OU=Groups - Distribution,DC=idaptive,DC=com"
    }
  },
  {
    "Entities": [],
     "Row": {
      "DistinguishedName": "CN=dl-test,OU=IT & Helpdesk Support,DC=idaptive,DC=com"
    }
  },
}

See Also