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
    }
  }
 
]

Example Query

See Also