Question

Is there a way to export all members in a particular group/OU?

winnie.mutunga
Badge

Hi all! Is there a way to export all members in a particular group/OU?

22 replies

mgosto
Badge

You can do that right from Users. https://support.google.com/a/answer/7348070?hl=en


Open Thread in Slack
winnie.mutunga
Badge

Awesome, that solves the OU export but it doesn’t seem to work for google groups


Open Thread in Slack
mike-bc
Rank
Userlevel 5
Badge +2

You can do Group exports in BetterCloud @winnie.mutunga, may need to go to the old interface though (g.bettercloud.com)


Open Thread in Slack
mgosto
Badge

oh good point! In that case you can also use the Download Members option within a particular group


Open Thread in Slack
winnie.mutunga
Badge

Awesome thank you both!


Open Thread in Slack
mgosto
Badge

the down arrow in the top right


Open Thread in Slack
aoom
Badge

also GAM can do this



Open Thread in Slack
mike-bc
Rank
Userlevel 5
Badge +2

do you know the command by chance @aoom?



Open Thread in Slack
aoom
Badge

pretty sure it's just gam info group <groupname> and gam info org <orgname> but let me confirm



Open Thread in Slack
winnie.mutunga
Badge

Do you know whether GAM, BetterCloud or Google Admin can bulk export the groups/ous and their members?



Open Thread in Slack
mike-bc
Rank
Userlevel 5
Badge +2

Yep! Check out the 'Canned Reports' tab on this page: https://g.bettercloud.com/#base/reports/reports



Open Thread in Slack
mike-bc
Rank
Userlevel 5
Badge +2

there should be one for All Groups and Their Members



Open Thread in Slack
mike-bc
Rank
Userlevel 5
Badge +2

and then separately you can export a list of all users which would contain their OU



Open Thread in Slack
winnie.mutunga
Badge

Fantastic, thank you!



Open Thread in Slack
mgosto
Badge

Hey @mike-bc are you all planning to add the canned reports to app.bettercloud.com?



Open Thread in Slack
mike-bc
Rank
Userlevel 5
Badge +2

I know we are certainly working on beefing up reporting in app.bettercloud.com (cc: @ashley.humphries@michael.marks), but I'm not certain about those exact canned reports



Open Thread in Slack
mgosto
Badge

🤞



Open Thread in Slack
michael.marks
Rank
Badge +2

@ashley.humphries is out of the office this week, but I will make sure she follows up with you @mgosto on this!



Open Thread in Slack
nosubstitute
Badge

@winnie.mutunga and here's the recursive group-membership command for GAMADV-XTD3.



Open Thread in Slack
ashley.humphries
Rank
Badge

@mgosto Hello! I am Ashley, the Reporting PM at BetterCloud. Short answer is 8a04df38615ba454.jpg

My Design counterpart and I are looking to do lots of research (starting now!) on the subject to get a sense of what's the most critical for us to surface first. If you're passionate about canned reports, I'd love to have a conversation!



Open Thread in Slack
mgosto
Badge

Thanks Ashley! I like that your calendly link allows recipients to choose the platform of their choice. That's neat.



Open Thread in Slack
ashley.humphries
Rank
Badge

Thank you for saying so! I try to accommodate where possible :relaxed:

Reply