Purpose

To get a list of all Confluence users' last password change date. 

Solution

Run the following SQL query

SELECT cu.user_name, cua.attribute_name, cua.attribute_value 
FROM cwd_user_attribute cua 
INNER JOIN cwd_user cu 
ON cua.user_id = cu.id
WHERE cua.attribute_name = 'passwordLastChanged';

Confluence stores the password last changed time based on epoch time. Hence, to convert it to human readable format:

1. Truncate the attribute_value (timestamps) for each user to only 10 digits, instead of the 13 digits stored in Confluence DB.
    The extra three digits represent milliseconds and should be omitted before the conversion.
2. Navigate to the following link and convert the truncated values accordingly.
   • https://www.epochconverter.com