DSUsers

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_centrify.com",
           "Locked": false,
          "InternalName": "********-****-****-****-************",
          "StatusEnum": "Created",
           "ServiceInstanceLocalized": "Active Directory (centrify.com)",
          "ServiceType": "AdProxy",
          "_MatchFilter": null,
          "Forest": "centrify.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=centrify,DC=com",
          "ServiceInstance": "AdProxy_centrify.com",
          "Locked": null,
          "InternalName": "********-****-****-****-************",
          "StatusEnum": "Created",
          "ServiceInstanceLocalized": "Active Directory (centrify.com)",
          "ServiceType": "AdProxy",
          "_MatchFilter": null,
          "Forest": "centrify.com",
          "EMail": "test1.support@h-5inm3hp79ld9mhto4narac8rl.3-vkqeae.na6.case.salesforce.com",
          "Status": "Not Invited",
          "Enabled": null
        }
      }