Posts

Showing posts from July, 2020

Find Active, Inactive, total users in all public group across Salesforce Org

If you have come across requirement, where you have to do clean-up of groups and you have no idea where to start. You can prepare a list of Groups and check the count of Total, Inactive, Active users in those groups and reach some conclusion. I have prepared an apex code script, which does the same job and the final output is CSV file text which you can copy and paste in CSV file and get the final result. output String :: GroupId total inactive 00G2v000004FWzCEAW 1 1 00G90000001mENyEAM 2 1 00G90000001mEO3EAM 1 1 Final Outcome will be like this  GroupId   total   inactive   Active(do csv formula)  00G2v000004FWzCEAW  1  1  0  00G2v000004FWzCEAM  2  1  1  00G90000001mEO3EAM  1  1  0

Find Active, Inactive and Total users per Role vise across salesforce Org

Below script will be useful when we have to find out Active/Inactive/Total users across sf org and No of roles are so many, so doing thing manually won't work. I have prepared below apex script which can be execute in developer console or workbench execute anonymous window. I hope this will be useful for you. Output will be like this when copied in csv file .  RoleId   total   inactive    00E900000016i8gEAA  1  null  00E900000016i8oEA   1  1