Return all groups with their details

5,449 views
Skip to first unread message

Mitchell Hoffman

unread,
Aug 11, 2021, 1:46:16 PM8/11/21
to GAM for Google Workspace
Afternoon Gammers!
Is there a way to return all groups and there details to a file, like gam print users all fields > users.csv.

Thanks in adcance for any advice

Ross Scroggs

unread,
Aug 11, 2021, 2:10:29 PM8/11/21
to google-ap...@googlegroups.com
Mitchell,

What do you mean by details?
This will get you the settings:
gam print groups allfields > groups.csv

This adds member info:
gam print groups allfields members manager owners> groups.csv

Ross


--
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/31fc5ed6-9b06-456a-a814-cfb340305d2fn%40googlegroups.com.


--

Mitchell Hoffman

unread,
Aug 11, 2021, 2:18:14 PM8/11/21
to GAM for Google Workspace
Sorry Ross, 
Should have added.
The group name, members, posting permissions etc.

As in gam print users fields name,email, is there a similar way to say
for groups 
gam print groups fields name,members

thank you

Kim Nilsson

unread,
Aug 12, 2021, 3:02:36 AM8/12/21
to GAM for Google Workspace
There is a members option for print groups, but there is also a completely separate print group-members command, if you want the users list in a different format.

Temple Rodgers

unread,
Aug 12, 2021, 6:57:00 AM8/12/21
to GAM for Google Workspace
I regularly run this command to list all the groups, their members and ACLs and update a sheet where I keep them
gam print groups email members todrive tdfileid <fileid> tdupdatesheet tdsheet "Sheet Filename - Groups"

Mitchell Hoffman

unread,
Aug 13, 2021, 8:32:15 AM8/13/21
to GAM for Google Workspace
Thanks for the suggestions
And I should have been able to get this from the wiki, but Ross pointed to the exact command I needed

gam redirect csv ./groupsdetails.csv print groups fields name,description

Can just pick and choose whichever fields are needed.

Brian Pugh

unread,
Mar 3, 2023, 11:51:30 AM3/3/23
to GAM for Google Workspace
This command worked well; however is it possible for a GAM command to get also all the Direct and Indirect Members of a group?

Thanks very much,

Brian

On Wednesday, August 11, 2021 at 2:10:29 PM UTC-4 Ross Scroggs wrote:

Ross Scroggs

unread,
Mar 3, 2023, 12:18:07 PM3/3/23
to google-ap...@googlegroups.com

Brian Pugh

unread,
Mar 3, 2023, 1:36:00 PM3/3/23
to GAM for Google Workspace
This will be very useful! Thank you, Ross.

Brian

Reply all
Reply to author
Forward
0 new messages