Resetting passwords of all newly imported users

[sumedh inamdar]

We imported users into Crowd in bulk.

While importing, we used a default password for all of them.

Now we want all of them to reset their passwords. How do we do that?

I found this - https://jira.atlassian.com/browse/CONF-30236 but it's marked as duplicate of another issue that seems still open.

[Septa Cahyadiputra [Atlassian]]

Hi Sumedh,

There is no such a way to do this for now. I have created a new feature request for Crowd as the mentioned link is for Confluence:

https://jira.atlassian.com/browse/CWD-4058

I investigate this issue further and find a workaround that might work for your end. Please try the following steps:

1. Create a database backup of your Crowd for safety precaution

2. Execute this SQL and note the directory_id of the directory that the newly imported users were imported 

   SELECT * FROM cwd_directory;

3. Once you get the directory_id, execute this SQL query:  This will reset all users from the directory 

   UPDATE cwd_user_attribute SET attribute_value = 'true' WHERE attribute_name = 'requiresPasswordChange' AND directory_id = <Input Directory ID>;

Hope it helps.

Cheers,
Septa Cahyadiputra