AllUsers
Returns a complete list of all registered users in the Confluence instance, including both active and disabled accounts. This view is only available for server deployments.
View-Specific Information
Select
The add-in uses the Confluence API to process WHERE clause conditions built with the following column and operator:
- UserKey supports the = operator.
SELECT * FROM AllUsers WHERE UserKey = '1234567890abcdef'
The add-in processes other filters client-side.
Note: This view is only available for Confluence Server deployments. Queries against this view fail in Confluence Cloud.
Columns
| Name | Type | References | SupportedOperators | Description |
| UserKey [KEY] | String | = | Unique identifier that distinguishes each user within the Confluence instance. Used to reference the user across related tables and views. | |
| UserName | String | The username associated with the user account, typically used for login and identification purposes. | ||
| Status | String | Indicates whether the user account is active, disabled, or pending activation. | ||
| Type | String | Specifies the user account type, such as internal or external, depending on how the user was created or synchronized. | ||
| ProfilePicturePath | String | The file path or URL that points to the user's profile picture stored in Confluence. | ||
| ProfilePictureWidth | Integer | The width, in pixels, of the user's profile picture. | ||
| ProfilePictureHeight | Integer | The height, in pixels, of the user's profile picture. | ||
| IsDefaultPicture | Boolean | If the value is 'true', the profile picture has never been changed and remains the system default. If the value is 'false', the user has uploaded a custom image. | ||
| DisplayName | String | The display name shown for the user throughout Confluence, such as in comments, mentions, or activity feeds. |