The DSUsers table contains users from all directory services used by the tenant.

Column

Type

Description

InternalName

String

User's name internal to the directory service (if any) (primary key).

SystemName

String

User's system name (login name).

DisplayName

String

User's display name.

Description

String

Descriptive text for the user.

StatusEnum

String

User status; will be one of Created, Suspended, Invited, or Active.

Status

Localized String

Localized user status; will be one of (localized) Created, Suspended, Invited, or Active.

Enabled

Boolean

Whether user is enabled.

Locked

Boolean

Whether user is locked.

Email

String

User's email address.

ServiceInstance

String

Name of the directory service to which the user belongs.

ServiceInstanceLocalized

String

Localized name of the directory service to which the user belongs.

ServiceType

Localized String

Type of the directory service to which the user belongs (Cloud, Active directory, LDAP, etc.)

DirectoryServiceUuid

String

UUID of the directory service the user is from.

Forest

String

Active directory forest of the user (present for Active Directory users only).

Example Query
The query searches the DSUsers table for users with "test" in their login name.

{
Script: "Select * from DSUsers 
    WHERE SystemName LIKE '%test%' 
    ORDER BY InternalName 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": "DsUsers",
             "Key": "********-****-****-****-************",
             "IsForeignKey": false
          }
        ],
        "Row": {
          "Description": null,
          "DisplayName": "test22",
          "DirectoryServiceUuid": "********-****-****-****-************",
          "SystemName": "[email protected]",
          "ServiceInstance": "AdProxy_idaptive.com",
           "Locked": false,
          "InternalName": "********-****-****-****-************",
          "StatusEnum": "Created",
           "ServiceInstanceLocalized": "Active Directory (idaptive.com)",
          "ServiceType": "AdProxy",
          "_MatchFilter": null,
          "Forest": "idaptive.com",
          "EMail": null,
          "Status": "Not Invited",
          "Enabled": true
        }
      },
      {
        "Entities": [
           {
            "Type": "User",
            "Key": "********-****-****-****-************",
            "IsForeignKey": true
           },
          {
            "Type": "DsUsers",
             "Key": "********-****-****-****-************",
            "IsForeignKey": false
          }
        ],
        "Row": {
           "Description": null,
          "DisplayName": "Test1 Support",
          "DirectoryServiceUuid": "********-****-****-****-************",
          "SystemName": "CN=Test1 Support,CN=Users,DC=idaptive,DC=com",
          "ServiceInstance": "AdProxy_idaptive.com",
          "Locked": null,
          "InternalName": "********-****-****-****-************",
          "StatusEnum": "Created",
          "ServiceInstanceLocalized": "Active Directory (idaptive.com)",
          "ServiceType": "AdProxy",
          "_MatchFilter": null,
          "Forest": "idaptive.com",
          "EMail": "[email protected]sforce.com",
          "Status": "Not Invited",
          "Enabled": null
        }
      }