Skip to content

Instantly share code, notes, and snippets.

@aevdokimenko
Last active April 30, 2018 17:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aevdokimenko/1a4d31d44a52f8778abaff961ca96a07 to your computer and use it in GitHub Desktop.
Save aevdokimenko/1a4d31d44a52f8778abaff961ca96a07 to your computer and use it in GitHub Desktop.
Getting top Chatter groups for you SFDC org
-- Using locally copied tables by DBAmp
select name, membercount, id, LastFeedModifiedDate
from CollaborationGroup
where isarchived = 'false' and MemberCount > 100 order by membercount desc
-- or the same using openquery
select *
from openquery(salesforce, 'select name, membercount, id, LastFeedModifiedDate
from CollaborationGroup where isarchived = false and MemberCount > 100 order by membercount desc')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment