The ADUser table contains all users who belong to Active Directory.

Column

Type

Description

ObjectGUID

String

User's UUID (primary key).

UserPrincipalName

String

User's principal name.

SamAccountName

String

User's Sam Account name.

DistinguishedName

String

User's distinguished name.

Mail

String

User's email address.

Name

String

User's login name.

Enabled

Boolean

Whether user is enabled.

Locked

Boolean

Whether user is locked.

Example Query

The following query searches the ADUser table for users with "test" in their login name.

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

The query returns all users with "test" in their login name.

ADUser table query response:

...
"FullCount": 2,
"Results": [
  {
    "Entities": [
      {
        "Type": "User",
        "Key": "********-****-****-****-************",
        "IsForeignKey": true
      },
      {
         "Type": "ADUser",
        "Key": "********-****-****-****-************",
        "IsForeignKey": false
       }
    ],
    "Row": {
      "DistinguishedName": "CN=adam test,OU=VPN - Temporary,DC=idaptive,DC=com",
      "Locked": null,
      "Mail": "[email protected]",
       "Name": "adam test",
      "UserPrincipalName": "[email protected]",
      "ObjectGUID": "********-****-****-****-************",
      "SamAccountName": "adam.test",
       "Enabled": null
    }
  },
  {
    "Entities": [
      {
        "Type": "User",
        "Key": "********-****-****-****-************",
        "IsForeignKey": true
      },
      {
        "Type": "ADUser",
        "Key": "********-****-****-****-************",
         "IsForeignKey": false
      }
    ],
    "Row": {
      "DistinguishedName": "CN=apptest,OU=Test Account,DC=idaptive,DC=com",
      "Locked": null,
      "Mail": null,
      "Name": "apptest",
      "UserPrincipalName": "[email protected]",
      "ObjectGUID": "********-****-****-****-************",
      "SamAccountName": "apptest",
      "Enabled": null
    }
  }
 
]

See Also