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": "********-****-****-****-************",
    }
  }
 
]

Example Query

See Also