Last active
April 30, 2018 17:50
-
-
Save aevdokimenko/1a4d31d44a52f8778abaff961ca96a07 to your computer and use it in GitHub Desktop.
Getting top Chatter groups for you SFDC org
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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