User

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, 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": "mdkline1@mac.com",
      "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": "my.user@mydomain.com",
      "Username": "cloudadmin@mytenant",
      "Forest": null,
       "SourceDs": "CDS",
      "Status": "Active",
      "ID": "********-****-****-****-************",
      "SourceDsType": "CDS"
    }
  }
 
]