Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ed055Ed055 

chatter reports/query

I'm trying to pull all the users who have not posted anything (user feed , group feed etc) on chatter. Is there a way to query SOSQL  or report to find out users who have never posted anything on chatter. Thanks.
KaranrajKaranraj
Check this free appexchange package for Chater usage - https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003IYLqEAO
Ed055Ed055
Karanraj - thank you for your response. we have installed this app but it does not show which users have never used. Also there is lot of confusion with this app with group feed and feed items etc. Group feeds are seperate from user feeds. I thought I could just query directly in developer console. Need help with the query
KaranrajKaranraj
Try the below code to get the list of users who didn't post anything in user feed or group feed 
  
List<Id> userIds = new List<Id>();
for(ChatterActivity chatterId: [SELECT Id, PostCount, LikeReceivedCount,ParentId FROM ChatterActivity]) {
userIds.add(chatterId.ParentId);    
}
List<user> userId = [select id,username from user where Id Not IN:userIds];
System.debug('User id list'+ userId);