Loading

Freeze or unfreeze multiple Users at once

Date de publication: Oct 13, 2022
Description


You can freeze a User account instead of deactivating them. This is intended to be used in situations where the User account requires more work before deactivating it. To learn how to do this for one User via the UI, please review Freeze or Unfreeze User Accounts.

It is also possible to freeze multiple Users at once, by using the latest version of Data Loader.
 

Résolution

The User property 'Frozen' is controlled in the object 'UserLogin' by the field 'IsFrozen.'  IsFrozen is a boolean field so it is either 'true' (frozen) or 'false.' 

System Administrators can use Data Loader to export and update the UserLogin object.
 
1. Run an Export using Data Loader from the UserLogin object (Note: Select the Show all Salesforce objects checkbox).

2. Select the Id, UserId, IsFrozen fields and complete the export.

Query example: Select UserId, Id, IsFrozen FROM UserLogin

Note: It's not possible to export additional user details such as Full Name, Username, or Email on export of UserLogin records. It's recommended to perform a secondary Export against the standard User object for reference:
 
Query Example: Select Id, Username, Name, Email FROM User
 
Combine the details from the two resulting export files using Excel VLOOKUP function. Populate or bring over the UserLogin Id into the User export file via matching Users Ids between the two files. Reference the How to Prepare Your CSV File Using Vlookup in Excel screencast for an example of Vlookup in action.
 
3. Edit the .csv file and change the IsFrozen field to TRUE for any Users you want to Freeze or FALSE to unfreeze.

4. Run an update using Data Loader on the UserLogin object and use the updated .csv file you created above.

Note: Use the Id of the UserLogin record rather than the UserId to update. 




See also:
Installing Data Loader
 
Numéro d’article de la base de connaissances

000387522

 
Chargement
Salesforce Help | Article