Print this page

Report on members in a Group

Knowledge Article Number 000220037
Description

The ability to track and report on Chatter usage can be incredibly valuable for tracking engagement. We'll show you how you can get the information you're looking for by using the Data Loader.

Resolution

1. In Data Loader, click UserOrGroupId FROM GroupMember WHERE GroupId = <YourgroupID >
    - All IDs beginning with 005 refers to users within a group.
2. Once the ID is exported to CSV, open the file in excel.
3. Use the formula left(text,15).
    - This is to parse the 15 character ID from the 18 character ID.
4. Once you have the 15 character ID, use this ID to query on user object to get the list of user names.

To help make this a part of Salesforce, go to Salesforce Ideas and vote for the idea





promote demote