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"
    }
  },
}

Example Query

See Also