How to get information on growth of active users year over year
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
Some Jira Admins may need to plan ahead on userbase growth, in order to plan and request license upgrades in the near future.
Currently, Jira does not provide any user base reporting tool that can provide such information.
Solution
It is possible to get an SQL output of userbase growth, grouped by year or month so that admins can use this data to request license upgrades or rearrange the license sits:
The following SQL query will show users created per year:
1
2
3
4
5
SELECT DATE_PART('year', created_date) AS year_created, COUNT(id)
FROM cwd_user
WHERE active = '1'
GROUP BY year_created
ORDER BY year_created;Alternatively, the third-party App User Manager for Jira can provide with some useful userbase reports, such as usage per users, active users, users created x deactivated and mor.
Was this helpful?