How to retrieve from the database the last time users set their password

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

In Jira Data Center, you can find when users last changed their password by querying Jira's database.

Solution

The easiest way to get information for users in Jira that have set their password is from the cwd_user_attributes table.
You can run the following SQL query against Jira's database to retrieve details for all users:

SELECT cu.user_name, cua.attribute_name, to_timestamp(CAST(cua.attribute_value as bigint)/1000) as "passwordLastChanged"
FROM cwd_user_attributes cua 
INNER JOIN cwd_user cu 
ON cua.user_id = cu.id
WHERE cua.attribute_name = 'passwordLastChanged';

Last modified on Jun 27, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.