How to get the total number of users in Jira Server and Data Center
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Having too many users in your Jira Data Center instance can result in instance instability and increase the time for directory synchronization and user authentication.
If you’re experiencing performance issues or want to make sure that you don’t exceed the recommended guardrails, you should check the total number of users in your system.
Solution
To get the total number of users in your instance, run the appropriate query against your database:
Run the following query if you're using PostgreSQL, MySQL, or Oracle Database:
1
2
3
SELECT DISTINCT count(lower_email_address)
AS user_count
FROM cwd_user;Run the following query if you're using Microsoft SQL Server:
1
2
3
SELECT DISTINCT count(lower_email_address)
as user_count
FROM [jiraschema].cwd_user; Was this helpful?