The User table contains all the users who have accessed the cloud service. It includes users from all directory services used by the tenant.

Column	Type	Description
ID	String	User's `UUID` (primary key).
Username	String	User's name.
DisplayName	String	User's display name.
Email	String	User's email address.
LastLogin	DateTime	Date/time the user last logged in to the cloud.
LastInvite	DateTime	Date/time the user was last invited to the cloud.
StatusEnum	String	User status; one of: Created, Suspended, Invited, or Active.
Status	Localized String	Localized user status; one of (localized): `Created`, `Suspended`, `Invited`, or `Active`.
SourceDs	String	Name of the directory service to which the user belongs.
SourceDsLocalized	Localized String	Localized name of the directory service to which the user belongs.
SourceDsType	String	Type of the directory service to which the user belongs (Cloud, Active Directory, LDAP, etc.).
DirectoryServiceUuid	String	`UUID` of the directory service used by the user.
Forest	String	Active Directory forest of the user (AD users only).

Example Query

The following query returns all entries in the User table where the DirectoryServiceUuid matches the specified value.

{
Script: "Select * from User 
    Where DirectoryServiceUuid = '09B9A9B0-6CE8-465F-AB03-65766D33B05E' 
    ORDER BY Username COLLATE NOCASE"

User table query response:

...
"FullCount": 2,
"Results": [
  {
    "Entities": [
      {
        "Type": "User",
        "Key": "********-****-****-****-************",
        "IsForeignKey": false
      }
    ],
    "Row": {
       "DisplayName": "A P Manson",
      "DirectoryServiceUuid": "********-****-****-****-************",
      "LastInvite": "/Date(1436985457356)/",
      "LastLogin": null,
      "SourceDsLocalized": "Cloud",
      "StatusEnum": "Invited",
      "_MatchFilter": null,
      "Email": "[email protected]",
      "Username": "apman@mdk",
       "Forest": null,
      "SourceDs": "CDS",
      "Status": "Invited",
      "ID": "********-****-****-****-************",
      "SourceDsType": "CDS"
    }
 
},
 
{
    "Entities": [
      {
        "Type": "User",
        "Key": "********-****-****-****-************",
         "IsForeignKey": false
       }
    ],
     "Row": {
      "DisplayName": "cloudadmin",
      "DirectoryServiceUuid": "********-****-****-****-************",
      "LastInvite": null,
      "LastLogin": "/Date(1435592142208)/",
      "SourceDsLocalized": "Cloud",
      "StatusEnum": "Active",
      "_MatchFilter": null,
      "Email": "[email protected]",
      "Username": "cloudadmin@kowang",
      "Forest": null,
       "SourceDs": "CDS",
      "Status": "Active",
      "ID": "********-****-****-****-************",
      "SourceDsType": "CDS"
    }
  }
 
]

Example Query

See Also