function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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.
Check this free appexchange package for Chater usage -
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
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]) {
List<user> userId = [select id,username from user where Id Not IN:userIds];
System.debug('User id list'+ userId);