Getting all groups and it's members via Data loader in Salesforce

1. Extract Group Members using the below query.

SELECT Group.Name, UserOrGroupId FROM GroupMember

2. Extract Users using the below query.

SELECT Id, Name FROM User

3. Use VLOOKUP to find the name of the user using UserOrGroupId from GroupMember.

Cheers!!!

No comments:

Post a Comment