Saturday, February 1, 2014

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.

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 query
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 rule set created by Salesforce Lab:
- http://appexchange.salesforce.com/listingDetail?listingId=a0N30000003IX0UEAW
- http://appexchange.salesforce.com/listingDetail?listingId=a0N30000003GGRwEAO
Posted in: ,,,,

 
| ,