要約

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.

環境

Bitbucket Server

ソリューション

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 

SELECT * FROM cwd_user WHERE CAST(created_date AS Date) >= 'YYYY-MM-DD'

Oracle の場合 

 SELECT * FROM cwd_user WHERE CAST(created_date AS Date) >= 'DD-MM-YYYY';