On this page

    SYS.ORGANIZATION.USERS

    The sys.organization.users table contains metadata for users in an organization.

    Syntax
    SELECT * 
    FROM sys.organization.users
    

    Example Output

    user_iduser_namefirst_namelast_namestatususer_typecreatedowner_idowner_typecreated_by
    1ebd39a7-d571-4edb-b113-206eb263c775test.user@dremio.comTestUseractiveEXTERNAL2021-12-10 04:43:50.902empty textuserSCIM
    80702009-37c5-454c-93f2-ec41ea1722eddremio.admin@dremio.comGnarlyempty textactiveLOCAL2021-12-10 04:54:13.093empty textuserLOCAL
    5aabeeae-8d3b-4dcc-ba04-051e5b08b11atest.user2@dremio.comempty textempty textinvitedEXTERNAL2021-10-05 18:07:32.377empty textuserSCIM

    Fields

    FieldData TypeDescription
    user_idvarcharThe UUID to identify the user.
    user_namevarcharThe email of the user is used as the username.
    first_namevarcharThe first name of the user.
    last_namevarcharThe last name of the user.
    statusvarcharThe state of the user depending on if they have accepted the invite to the organization and have logged in to the application.
    Enum: active, invited
    user_typevarcharThe type of user based on how it was created.
    Enum: EXTERNAL, LOCAL
    createdtimestampThe timestamp for when the user was created.
    owner_idvarcharThe UUID for the owner (user or role) of the user. This UUID corresponds to the user_id or role_id in the users or roles table.
    owner_typevarcharThe type of owner of the user.
    Enum: user, role
    created_byvarcharThe method of creation.
    Enum: LOCAL, SCIM