How to mass update resource passwords
QUESTION
We used windows authentication for Changepoint, not the application authentication so we do not use the password field on the user set up screen. However, we have a need to mass update this field. I see it's an encrypted column in the database so don't think I can just do an update statement. How can I update this field for everyone? Manually setting it is not an option due to the effort required.
REASON
Mass update for passwords are not currently possible as the encryption cannot be done through a SQL statement. Also, the encryption uses resource specific information so passwords cannot be copied from one resource to another.
RESOLUTION
Password mass update would need a customization/customer specific script or program.