Skip to Content

TheBlogReaders.com

Salesforce.com, PHP, MySQL, Javascript, Ajax, Htacces

Users Freeze or UnFreeze in Salesforce using Script

Be First!

Users Freeze or UnFreeze in Salesforce using Script

User Freeze/Unfreeze information captured in the UserLogin Object.

User Freeze/Unfreeze is possible in two ways:

  1. Using DataLoader
  2. Execute scripts in Developer console -> Execute Anonymous Window

1. DataLoader

  • Run an Export using DataLoader from the UserLogin object (Note: tick the “Show all Salesforce objects” checkbox)
  • Select the Id, UserId, IsFrozen fields
  • Edit the csv file and change the IsFrozen field to TRUE for any users you want to Freeze or FALSE to unfreeze.
  • Run an Update using DataLoader on the UserLogin object and use the updated csv file you created above.

For More Information: https://help.salesforce.com/articleView?id=000187696&language=en_US&type=1

2. Scripts

#########################User-Freeze##############################
//Internal users – Freeze
List<UserLogin> listInternalUserFreeze = [select id, isfrozen, userid from UserLogin where userid in (select id from user where profile.name in (‘System Administrator’, ‘Sales Rep’) and isactive=true)];
if(listInternalUserFreeze != null && !listInternalUserFreeze.isEmpty()) {
for(UserLogin u : listInternalUserFreeze) {
u.isfrozen = true;
}
update listInternalUserFreeze;
}

//partner users – Freeze
List<UserLogin> listPartnerUserFreeze = [select id, isfrozen, userid from UserLogin where userid in (select id from user where profile.name in (‘Partner’) and isactive=true)];
if(listPartnerUserFreeze != null && !listPartnerUserFreeze.isEmpty()) {
for(UserLogin u : listPartnerUserFreeze) {
u.isfrozen = true;
}
update listPartnerUserFreeze;
}

#######################################################User-Unfreeze###########################
//Internal users – Unfreeze
List<UserLogin> listInternalUserFreeze = [select id, isfrozen, userid from UserLogin where userid in (select id from user where profile.name in (‘System Administrator’, ‘Sales Rep’) and isactive=true)];
if(listInternalUserFreeze != null && !listInternalUserFreeze.isEmpty()) {
for(UserLogin u : listInternalUserFreeze) {
u.isfrozen = false;
}
update listInternalUserFreeze;
}

//partner users – Unfreeze
List<UserLogin> listPartnerUserFreeze = [select id, isfrozen, userid from UserLogin where userid in (select id from user where profile.name in (‘Partner’) and isactive=true)];
if(listPartnerUserFreeze != null && !listPartnerUserFreeze.isEmpty()) {
for(UserLogin u : listPartnerUserFreeze) {
u.isfrozen = false;
}
update listPartnerUserFreeze;
}

To check user freeze/unfreeze in the user detail page of salesforce:

 

(5)

Previous
Next

Leave a Reply