List all members of a group, including member of its nested groups
2,919 views
Skip to first unread message
Filippo Nardin
Mar 30, 2017, 11:24:32 AM3/30/17
to GAM for G Suite
There was a similar question a few years back, but I could not find an answer to it in the forum. Basically, we organize our mailing lists in a tree (nested) structure. I would like to create a list of email recipients for a given group, including its nested groups. We have several level of nesting. I cannot use orgs as many of these recipient are external email addresses. Ideally, the list would not have duplicates (which exists, as many recipients are members of different groups within the same tree structure).
Before I start using google sheets to solve this, I was wondering if there is a gam syntax that would accomplish the same.
Thanks!
Ross Scroggs
Mar 30, 2017, 1:01:03 PM3/30/17
to google-ap...@googlegroups.com
Filippo,
Regular Gam can't do this, in my advanced Gam (https://github.com/taers232c/GAMADV-X) you cam.
$ gam print group-members group testgroup1
Getting all Members for testg...@domain.com
id,role,group,email,type,status
100763751091086757711,OWNER,testg...@domain.com,ad...@domain.com,USER,ACTIVE
111394551153366998689,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE
105694278649228462764,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE
104847893811441160587,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE
03cqmetx3wl3ck5,MEMBER,testg...@domain.com,testg...@domain.com,GROUP,ACTIVE
118080758787650801331,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE
107344800159717682514,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE
$ gam print group-members group testgroup1 recursive
Getting all Members for testg...@domain.com
Getting all Members for testg...@domain.com
id,role,group,email,type,status,level,subgroup
107344800159717682514,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE,1,testg...@domain.com
109097381978066352282,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE,1,testg...@domain.com
118080758787650801331,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE,0,testg...@domain.com
107344800159717682514,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE,0,testg...@domain.com
$ gam print group-members group testgroup1 recursive noduplicates
Getting all Members for testg...@domain.com
Getting all Members for testg...@domain.com
id,role,group,email,type,status,level,subgroup
107344800159717682514,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE,1,testg...@domain.com
109097381978066352282,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE,1,testg...@domain.com
118080758787650801331,MEMBER,testg...@domain.com,test...@domain.com,USER,ACTIVE,0,testg...@domain.com
$
Ross
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/55f07ac2-dae9-4cbf-82a2-0413f6154082%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Filippo Nardin
Mar 30, 2017, 2:47:51 PM3/30/17
to GAM for G Suite
Thanks Ross, it works like a charm in advanced Gam! Look forward to learning more about gamadv-x. Filippo
On Thursday, March 30, 2017 at 1:01:03 PM UTC-4, Ross Scroggs wrote:
Filippo,Regular Gam can't do this, in my advanced Gam (https://github.com/taers232c/GAMADV-X) you cam.
$ gam print group-members group testgroup1Getting all Members for testg...@domain.comid,role,group,email,type,status
100763751091086757711,OWNER,testgr...@domain.com,ad...@domain.com,USER,ACTIVE111394551153366998689,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE105694278649228462764,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE104847893811441160587,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE03cqmetx3wl3ck5,MEMBER,testgrou...@domain.com,testg...@domain.com,GROUP,ACTIVE118080758787650801331,MEMBER,testg...@domain.com,testuser1@domain.com,USER,ACTIVE107344800159717682514,MEMBER,testg...@domain.com,testuser2@domain.com,USER,ACTIVE
$ gam print group-members group testgroup1 recursiveGetting all Members for testg...@domain.comGetting all Members for testg...@domain.comid,role,group,email,type,status,level,subgroup
100763751091086757711,OWNER,testgr...@domain.com,ad...@domain.com,USER,ACTIVE,0,testgro...@domain.com111394551153366998689,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE,0,testgro...@domain.com105694278649228462764,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE,0,testgro...@domain.com104847893811441160587,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE,0,testgro...@domain.com107344800159717682514,MEMBER,testg...@domain.com,testuser2@domain.com,USER,ACTIVE,1,testgro...@domain.com109097381978066352282,MEMBER,testg...@domain.com,testuser3@domain.com,USER,ACTIVE,1,testgro...@domain.com118080758787650801331,MEMBER,testg...@domain.com,testuser1@domain.com,USER,ACTIVE,0,testgro...@domain.com107344800159717682514,MEMBER,testg...@domain.com,testuser2@domain.com,USER,ACTIVE,0,testgro...@domain.com
$ gam print group-members group testgroup1 recursive noduplicatesGetting all Members for testg...@domain.comGetting all Members for testg...@domain.comid,role,group,email,type,status,level,subgroup
100763751091086757711,OWNER,testgr...@domain.com,ad...@domain.com,USER,ACTIVE,0,testgro...@domain.com111394551153366998689,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE,0,testgro...@domain.com105694278649228462764,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE,0,testgro...@domain.com104847893811441160587,MEMBER,testg...@domain.com,us...@domain.com,USER,ACTIVE,0,testgro...@domain.com107344800159717682514,MEMBER,testg...@domain.com,testuser2@domain.com,USER,ACTIVE,1,testgro...@domain.com109097381978066352282,MEMBER,testg...@domain.com,testuser3@domain.com,USER,ACTIVE,1,testgro...@domain.com118080758787650801331,MEMBER,testg...@domain.com,testuser1@domain.com,USER,ACTIVE,0,testgro...@domain.com$Ross
On Mar 30, 2017, at 8:18 AM, Filippo Nardin <goo...@gisbos.org> wrote:
There was a similar question a few years back, but I could not find an answer to it in the forum. Basically, we organize our mailing lists in a tree (nested) structure. I would like to create a list of email recipients for a given group, including its nested groups. We have several level of nesting. I cannot use orgs as many of these recipient are external email addresses. Ideally, the list would not have duplicates (which exists, as many recipients are members of different groups within the same tree structure).Before I start using google sheets to solve this, I was wondering if there is a gam syntax that would accomplish the same.Thanks!--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages