GroupsUsers
Retrieves mappings between users and their associated groups.
View Specific Information
Select
The connector utilizes the Jira API to process WHERE clause conditions that include the following columns and supported operators. Any remaining filters are applied client-side by the connector.
To effectively query the GroupsUsers view, you must specify a value for either the GroupName column or the GroupId column (the latter is exclusive to cloud instances). If neither GroupName nor GroupId is provided, the connector will automatically iterate through all groups to retrieve all associated users, which may result in increased query times.
As shown in the examples below, to retrieve users who belong to a specific group, include either the GroupName or GroupId in your query.
- Using GroupId:
SELECT * FROM GroupsUsers WHERE GroupId = '37f2babd-27ef-442e-8642-15b6cafba31c'
- Using GroupName:
SELECT * FROM GroupsUsers WHERE GroupName = 'jira-software-users'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| AccountId [KEY] | String | Cloud | The unique account ID of the user across all Atlassian products, used for identifying the user in a platform-wide context. | ||
| Key [KEY] | String | Server | The internal key used to identify the user within Jira. This can differ from the account ID. | ||
| GroupId [KEY] | String | = | Cloud | The unique identifier of the group that the user belongs to. Used to map group memberships. | |
| GroupName [KEY] | String | = | Common | The name of the group the user is associated with. Groups are often used for permission management. | |
| Name | String | Server | The Jira username of the user. This value can be deprecated in some contexts in favor of AccountId. | ||
| DisplayName | String | Common | The full display name of the user as shown in the Jira UI and user directories. | ||
| EmailAddress | String | Common | The email address associated with the user's Atlassian account. | ||
| Active | Bool | Common | If the value is 'true', the user is currently active and able to log in. If 'false', the account is inactive or suspended. | ||
| TimeZone | String | Common | The time zone configured in the user's profile, which affects how time-related data is displayed. | ||
| Locale | String | Cloud | The locale (language and region format) specified in the user's profile, used to localize the UI. | ||
| AccountType | String | Cloud | The type of account the user holds, such as 'atlassian' or 'app'. Useful for distinguishing user roles or access methods. | ||
| Products | String | Cloud | A comma-separated list of Jira products the user has access to. For example: jira-core, jira-servicedesk, jira-product-discovery, jira-software. |