How do I find out if a CEE hosted user's password has expired?

To find out if a CEE hosted user's password has expired (LAST_PASSWORD_CHANGE field in DB), and when the user last changed it, you must have Host Admin access, which is generally reserved for CollabNet Support only. If you have such access, follow the steps below to find if the user's password has expired.

AdHoc Query example to show how you can get the password last changed date. This can be very helpful if you need to find out if a user's password has expired.

Example 1 (one username)

Admin -> Ad Hoc Query 
SELECT LOGIN_NAME, LAST_PASSWORD_CHANGE from HELM_USER where LOGIN_NAME = 'username1'

Example 2 (multiple usernames)

 Admin -> Ad Hoc Query SELECT
LOGIN_NAME, LAST_PASSWORD_CHANGE from HELM_USER where LOGIN_NAME = 'username1' OR
LOGIN_NAME = 'username2' OR LOGIN_NAME = 'username3' OR 
LOGIN_NAME LIKE 'username4%'

This is an example on how Ops can update this field, if needed.

Example (only Ops can run this directly on the server)

mysql> UPDATE HELM_USER SET LAST_PASSWORD_CHANGE = NOW() 
WHERE LOGIN_NAME = 'username1' OR 
LOGIN_NAME = 'username2' OR LOGIN_NAME = 'username3' OR 
LOGIN_NAME LIKE 'username4%';
Query OK, 8 rows affected (0.00 sec)
Rows matched: 8 Changed: 8 Warnings: 0