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.

RiskLevel

String

The risk level assigned to the user: Normal, Low, Medium, High, Unknown, SystemUnavailable

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": "[email protected]",
       "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": "[email protected]",
      "Forest": null,
       "SourceDs": "CDS",
      "Status": "Active",
      "ID": "********-****-****-****-************",
      "SourceDsType": "CDS"
    }
  }
 
]

See Also