The CDUser table contains all users who are enrolled in the Cloud user service.

Column

Type

Description

ID

String

User's UUID (primary key).

DisplayName

String

User's display name.

Mail

String

User's email address.

Description

String

Descriptive text for the user.

OfficeNumber

String

User's office or work phone number.

MobileNumber

String

User's mobile (cell) phone number.

HomeNumber

String

User's home phone number.

Name

String

User's login name.

ReportsTo

String

UUID of the user to whom this user reports.

PictureUri

String

URI path to the user's picture file (if any).

Enabled

Boolean

Whether user is enabled.

Locked

Boolean

Whether user is locked.

LockedByAdmin

Boolean

If user is locked, whether it was an administrator's action.

InEverybodyRole

Boolean

Whether the user is in the Everybody role.

Example Query

The query searches the CDUser table for users with "or" in their email address.

{
Script: "Select * from CDUser 
    WHERE Mail LIKE '%or%' 
    ORDER BY Name COLLATE NOCASE"
}

The query returns entries with the letters 'or' in the email address.

CDUser table query response:

...
"FullCount": 2,
"Results": [
  {
    "Entities": [
      {
        "Type": "CDUser",
        "Key": "********-****-****-****-************",
        "IsForeignKey": false
      }
    ],
    "Row": {
      "Description": "",
      "DisplayName": "Corey Woobins",
      "PictureUri": null,
       "InEverybodyRole": false,
      "Locked": null,
       "MobileNumber": "**********",
      "LockedByAdmin": null,
      "OfficeNumber": "",
      "HomeNumber": "",
       "_MatchFilter": null,
      "ReportsTo": "Unassigned",
      "Name": "[email protected]",
       "Mail": "[email protected]",
      "Enabled": null,
      "ID": "********-****-****-****-************"
     }
  },
  {
    "Entities": [
      {
         "Type": "CDUser",
        "Key": "********-****-****-****-************",
        "IsForeignKey": false
       }
    ],
    "Row": {
      "Description": null,
      "DisplayName": "Faie Doral",
      "PictureUri": null,
      "InEverybodyRole": false,
      "Locked": null,
      "MobileNumber": null,
      "LockedByAdmin": null,
      "OfficeNumber": null,
      "HomeNumber": null,
      "_MatchFilter": null,
      "ReportsTo": "Unassigned",
      "Name": "[email protected]",
       "Mail": "[email protected]",
      "Enabled": null,
      "ID": "********-****-****-****-************",
    }
  }
 
]

See Also