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

Comments

Post a Comment

Popular posts from this blog

How to change/update the profile of a User in Salesforce from apex code

It's my first blog writing, so ignore all the grammatical errors here :) A user profile update is not allowed through apex code generally and it through error  FIELD_INTEGRITY_EXCEPTION, Cannot change profile for current user: Profile ID. It can be achieve by Http callout. How to do this, its pretty simple. There are 2 way to do this: 1st:  If we have community or a site enabled in our sf org. It's  3-4 step process. Create a visualforce page and assign a controller to it. Make this page public through guest user permissions. Define an action in apex:page tag.  which will be called when ever this page executes In controller : action: write the code to update the profileId. It works. 1 2 3 4 5 6 7 8 9 10 public void callPublicSite (){ String remoteURL = ' https: //testing.force.com/ProfileUpdate?userId=' userId+'&profileId='+profileIdToUpdate; HttpRequest httpRequest = new HttpRequest(); httpRequest. setM...
Read more

Deep Dive into Salesforce to Salesforce Connection

Image
Salesforce Connections are used to share data/records between 2  salesforce org of yours or with Partner. Terminology we need to understand more about salesforce connection and how it works. Source Org = Org which is used to share records and its data. Target Org =  Org which receive shared record. Connection User = A user under this operation of sharing and receiving are performed is known as "Connection User" with Profile "Partner Network". Settings and Configuration  In Setup :  go to Salesforce to Salesforce, and enable it first to use. Click on All Tabs at the navigation bar and look for Connections tab Click on  New Button to create a new Connection. Fill Contact (mandatory), Account, Connection Owner. Based on Contact Email Id, a Connection Invite email is sent to that mail id and that person/Partner User has to click on a link received in email and that link direct to login to sf org for login to their own org which wi...
Read more

File Migration from One Salesforce Org to Another Org using Skyvia

Image
File Migration Exporting a file is a tough task. File export with its binary data is not supported in most of the available tools in the market. (eg: Dataloader, Dataloader.io, workbench). However, we have the Skyvia web app, which does a really great job in file export and import.    We should pay attention to the following objects: ContentVersion(CV), ContentDocument (CD), ContentDocumentLink (CDL). I will use abbreviations for the above 3 objects further in this blog. A combination of these 3 is used for storing files in Salesforce. We will ideally export only two of them — ContentVersion and ContentDocumentLink.   ContentVersion : stores binary data of a file. A file can have multiple versions, but a user only sees LatestContentVersion by default. ContentDocument : there is always only 1 ContentDocument for a file. ContentDocument always contains LatestContentVersion id. ContentDocumentLink : connects a record to the file with the help of ContentDocumentId and Linke...
Read more