Friday, March 22, 2013

How to report Chatter records following by users?

As of Salesforce Spring '13 release, maximum people and records a user can follow in Chatter is 500. Once a user hit 500, user unable to follow any user or record, if you need more than 500 limit, you can log a case to Salesforce support to get this number increase.

Question, how to check number of people + records has been followed? Easy answer, click on user profile and it will show in right panel of count and items "Following". Then, you can click "Show All (number)" to see all records and people that user are following.

But, is there anyway to list all items following for all users? We cannot find in Chatter reports on this. If you are familiar with SOQL or Data Loader, this is possible...

The object that stored all 'following' is EntitySubscription.
EntitySubscription represents a subscription for a user following a record or another user. A user can subscribe to a record or to another user. EntitySubscription are available in API version 18.0 and later.

Here is the simple soql:
Select e.Id, e.SubscriberId, e.ParentId From EntitySubscription e order by e.SubscriberId
SubscriberId here is UserId and ParentId is any objects or users following.

If you do not want to auto-following records you created (so you not easily hit max 500), you can configure it from: Setup - Personal Setup - My Chatter Settings - My Feeds. Uncheck Automatically follow records that I create.

There are also application in AppExchange you can install to auto-unfollow Chatter items based on set of rules, this app created by Salesforce Lab:
- Cloud Swarm 3 - Chatter Auto Follow - Unmanaged - EE / UE / DE
- Chatter Unfollow Rules - Managed