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. |
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
}
}
Updated almost 5 years ago