How to Get a list of chatter groups that do not have any activity in last 6 months?

Question

I wanted to get list of chatter group that do not any posts and comments posted in last 6 months, so that we can take some action on those.

Answer 1

Just have to query the groups that have no FeedItems that were created in the last 6 months

Something like this should work

Date sixMonthsAgo= system.today().addMonths(-6);

List<CollaborationGroup> myGroup = [Select c.Name, c.Id From CollaborationGroup c 
Where Id NOT IN (SELECT ParentId FROM CollaborationGroupFeed Where CreatedDate >: sixMonthsAgo)];

Answer 2

I'd just wait, actually. Winter 14 will see the capability of archiving Chatter groups appear in Chatter. From the release notes:

"By default, groups are set to archive automatically if there are no new feed posts or comments for 90 consecutive days. Groups are reviewed for feed activity and automatically archived on a weekly basis.Group owners, group managers, and users with the "Modify All Data" permission can manually archive and activate groups, or enable and disable automatic archiving for a group at any time."

Begin educating your users today, because you know who they will come to when they suddenly see some group they created six months ago archived.