Moodle force password change

If you need to know where the force password change is set for a given user in the Moodle database, look in the mdl_user_preferences table for the value auth_forcepasswordchange. A value of 0 means a password change is not required while a 1 means the user will be forced to change their password.

This might be useful for example if you want to do a bulk force password change on a number of users.