The ADOU table contains the Active Directory organizational units used by the tenant.

Column

Type

Description

ObjectGUID

String

OU's UUID (primary key).

Name

String

OU's name.

Description

String

OU's description.

DistinguishedName

String

OU's distinguished name.

Example Query

The following example queries the ADOU table:

{Script: "Select * From ADOU ORDER BY Description COLLATE NOCASE"}

The query returns a list of Active Directory Organizational Units, ordered by Description.

ADOU table query response:

"FullCount": 2,
"Results": [
  {
    "Entities": [
      {
        "Type": "ADOU",
        "Key": "********-****-****-****-************",
        "IsForeignKey": false
      }
    ],
    "Row": {
      "DistinguishedName": "OU=Microsoft Exchange Security Groups,DC=idaptive,DC=com",
      "Name": "Microsoft Exchange Security Groups",
      "Description": null,
      "ObjectGUID": "********-****-****-****-************"
    }
  },
   {
    "Entities": [
      {
        "Type": "ADOU",
        "Key": "********-****-****-****-************",
        "IsForeignKey": false
      }
    ],
     "Row": {
      "DistinguishedName": "OU=IT & Helpdesk Support,DC=idaptive,DC=com",
      "Name": "IT & Helpdesk Support",
      "Description": null,
      "ObjectGUID": "********-****-****-****-************"
    }
  }

See Also