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": "********-****-****-****-************"
    }
  }

Example Query

See Also