Info_Users
Query user data within an organization for administrative and reporting purposes.
Table Specific Information
Select
Retrieve all Users.
SELECT * FROM Info_Users
Retrieve all Users of a specific Group.
SELECT * FROM Info_Users WHERE GroupId = '2928085806875091'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier assigned to each user, used to differentiate them within the system. | |
| AccountId | String | The unique identifier of the account to which the user belongs, establishing account association. | |
| AccountName | String | The name of the account associated with the user, providing a human-readable reference. | |
| String | The email address registered for the user, used for communication and login purposes. | ||
| Name | String | The user's full name as it appears in the system, combining first and last name. | |
| FirstName | String | The user's first name, typically used in personal greetings and identification. | |
| LastName | String | The user's last name, often used for formal identification. | |
| Admin | Boolean | Indicates whether the user is a system administrator with privileges to manage accounts and other users. | |
| Locale | String | The language and regional settings associated with the user, impacting date formats and other locale-specific elements. | |
| TimeZone | String | The user's timezone, used to localize date and time information across the platform. | |
| LicensedSheetCreator | Boolean | Indicates if the user holds a license to create and own sheets within the system. | |
| GroupAdmin | Boolean | Specifies whether the user can create and manage groups, granting them group admin privileges. | |
| ResourceViewer | Boolean | Indicates if the user has access to view resource management features such as workload views. | |
| Status | String | The current status of the user within the system. Possible values include: ACTIVE, PENDING, or DECLINED. | |
| GroupId | String | The unique identifier of the group to which the user belongs, if applicable. | |
| Company | String | The name of the company the user is associated with. Populated only when filtering by user Id. | |
| Department | String | The department within the company that the user is part of. Populated only when filtering by user Id. | |
| MobilePhone | String | The user's mobile phone number. This field is populated only when filtering by user Id. | |
| LastLogin | String | The timestamp of the user's last login. Only populated if the user has logged in and an Id filter is applied. | |
| Role | String | The role or position of the user within their organization. Populated only when filtering by user Id. | |
| Title | String | The professional title of the user within their organization. Populated only when filtering by user Id. | |
| WorkPhone | String | The user's work phone number. This field is populated only when filtering by user Id. |