Is there any way to obtain a report of all my Google groups and the users in each group?

[Mariano Schesak]

Hi team,

Good morning. I need your expertise please.

I am using GAM and I couldn't find a way to obtain a csv file for this.

I need to make a report of all my google groups, the users inside of each of these Google groups, and if possible, even the settings of each of these groups.

If the settings is too much, is there any way in GAM to obtain at least a report of all my Google groups and their members inside of each group?

Thank you team.

Regards,

Mariano.

[Ross Scroggs]

See: https://github.com/taers232c/GAMADV-XTD3/wiki/Groups#display-information-about-selected-groups

This will give you one row per group with settings. If you ask for members, manager or owners; the email addresses for each role will be space separated

is separate columns; this can make for a very wide file.

See: https://github.com/taers232c/GAMADV-XTD3/wiki/Groups-Membership#display-group-membership-in-csv-format

This will give you a row per group/member combination; no group settings are displayed.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/d4a14d81-131d-40df-93c3-f8a6f9fc72a7n%40googlegroups.com.

[Mariano Schesak]

Thank you very much Ross for your help.

Regards,

Mariano.

[Mariano Schesak]

Ross,

These commands are made to be used with advanced GAM right?

Not with the standard version.

Correct?

Thanks.

Mariano.

On Wednesday, August 7, 2024 at 9:49:07 AM UTC+12 Ross Scroggs wrote:

[Ross Scroggs]

Correct.

If you need to upgrade see: https://github.com/taers232c/GAMADV-XTD3/wiki/How-to-Upgrade-from-Standard-GAM

I can help you via Meet/Zoom if you'd like.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/40331588-e01a-4d19-83f8-c3aac3e56483n%40googlegroups.com.

[Mariano Schesak]

Hi Ross,

Thank you for the help. I just watched a video and managed to install and test advanced gam and it's working fine. I tested with a simple command: gam user xxxx...@xx.com check service account and it's passing every step successfully

Now, I've tried to copy this command fully and paste it into my CMD on the directory of GAM advanced, but it's showing me errors all over the place. This is the command I am pasting:

gam print group-members [todrive <ToDriveAttribute>*]
        [([domain|domains <DomainNameEntity>] ([member|showownedby <EmailItem>]|[(query <QueryGroup>)|(queries <QueryGroupList>)]))|
         (group|group_ns|group_susp <GroupItem>)|
         (select <GroupEntity>)]
        [emailmatchpattern [not] <RegularExpression>] [namematchpattern [not] <RegularExpression>]
        [descriptionmatchpattern [not] <RegularExpression>]
        [admincreatedmatch <Boolean>]
        [roles <GroupRoleList>] [members] [managers] [owners]
        [membernames] [showdeliverysettings]
        <MembersFieldName>* [fields <MembersFieldNameList>]
        [notsuspended|suspended] [notarchived|archived]
        [types <GroupTypeList>]
        [memberemaildisplaypattern|memberemailskippattern <RegularExpression>]
        [userfields <UserFieldNameList>]
        [(recursive [noduplicates])|includederivedmembership] [nogroupemail]
        [peoplelookup|(peoplelookupuser <EmailAddress>)]
        [unknownname <String>] [cachememberinfo [Boolean]]
        [formatjson [quotechar <Character>]]

That's to obtain the members of the groups and all the groups I have, but when I pasted the command I get 

Would you know why this could be failing of if I am doing something wrong?

Thanks for your help as usual Ross.

Regards,

Mariano.

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/EPY0n5_i_F4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/6B02DEB5-7995-4705-BF74-F3DB11E54569%40gmail.com.

--

Cheers
Mariano Schesak

Jr. Systems Administrator

205-209 Wairau Road, Wairau Valley

Auckland 0627

www.smartpay.co.nz                   

This email and any attachments may be confidential. If received in error, please delete the message and inform us by return email. Further, the internet contains many uncertainties and Smartpay cannot guarantee that what you receive is what we intended to send. Smartpay has taken great effort to verify the accuracy of this document but assumes no responsibility for any technical inaccuracies or typographical errors. If you have any doubts about the authenticity of an email from Smartpay, please contact us immediately. Please maintain an up to date virus scanner and think before you print. Thank you.

[Ross Scroggs]

What is shown in the Wiki is the BNF syntax for a command, you never type in that literal text.

See: https://github.com/taers232c/GAMADV-XTD3/wiki/BNF-Syntax

You interpret the BNF and type that in.

gam print group-members

gam print group-members group grou...@domain.com

gam print group-members roles owner

I'm in California (PDT GMT-7), it's about 6:05 PM.

If you send me a Meet/Zoom invitation  for 2:30PM your time (7:30 PM my time) I can help.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJ%2BkxkJFE1_QBZj%2BbWWC0UtJz-v2k5ukS_6uoN-nT3in-iN0Mw%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

[Ross Scroggs]

I'm available if you want to send me a Meet/Zoom invitation.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Aug 7, 2024, at 5:17 PM, 'Mariano Schesak' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

Hi Ross,

Thank you for the help. I just watched a video and managed to install and test advanced gam and it's working fine. I tested with a simple command: gam user xxxx...@xx.com check service account and it's passing every step successfully

Now, I've tried to copy this command fully and paste it into my CMD on the directory of GAM advanced, but it's showing me errors all over the place. This is the command I am pasting:

gam print group-members [todrive <ToDriveAttribute>*]
        [([domain|domains <DomainNameEntity>] ([member|showownedby <EmailItem>]|[(query <QueryGroup>)|(queries <QueryGroupList>)]))|
         (group|group_ns|group_susp <GroupItem>)|
         (select <GroupEntity>)]
        [emailmatchpattern [not] <RegularExpression>] [namematchpattern [not] <RegularExpression>]
        [descriptionmatchpattern [not] <RegularExpression>]
        [admincreatedmatch <Boolean>]
        [roles <GroupRoleList>] [members] [managers] [owners]
        [membernames] [showdeliverysettings]
        <MembersFieldName>* [fields <MembersFieldNameList>]
        [notsuspended|suspended] [notarchived|archived]
        [types <GroupTypeList>]
        [memberemaildisplaypattern|memberemailskippattern <RegularExpression>]
        [userfields <UserFieldNameList>]
        [(recursive [noduplicates])|includederivedmembership] [nogroupemail]
        [peoplelookup|(peoplelookupuser <EmailAddress>)]
        [unknownname <String>] [cachememberinfo [Boolean]]
        [formatjson [quotechar <Character>]]

That's to obtain the members of the groups and all the groups I have, but when I pasted the command I get 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJ%2BkxkJFE1_QBZj%2BbWWC0UtJz-v2k5ukS_6uoN-nT3in-iN0Mw%40mail.gmail.com.

[Mariano Schesak]

Hi Ross,

Sorry for the moment since I work in Auckland the timeframe is really tight but I managed to resolve this by using this command in GAM: gam print groups members > all_groups_and_members.csv

Using that one I exported the groups and the members inside of each group.

I now need to work to make the excel file tidier.

Again, thanks so much for your help on this one.

Regards,

Mariano.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/AB68ED31-161D-4735-9C4D-41D25BE0EE6A%40gmail.com.

[Ross Scroggs]

I am available for the next hour or so if you need help.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJ%2BkxkJ2sssz8MxCvMYf8he0grEoGAiFYDWf2YuaJP588HwU7g%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com