Find users by created date rather than last authenticated date
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
When looking for users (possibly in the case to remove some to free up licenses), the /admin/users endpoint only provides a last authenticated date and doesn't mention when the user was originally created.
Environment
Bitbucket Server
Solution
The following DB query can be run against your database to get users based on the created date. Note: This does not state if those users consume a license or any other information.
For PSQL
1
SELECT * FROM cwd_user WHERE CAST(created_date AS Date) >= 'YYYY-MM-DD'For Oracle
1
SELECT * FROM cwd_user WHERE CAST(created_date AS Date) >= 'DD-MM-YYYY';Was this helpful?