List all shared drives and all their members

6,394 views
Skip to first unread message

Constantly Learning

unread,
Feb 22, 2020, 9:16:51 AM2/22/20
to GAM for G Suite
Ross and others,

I ran a GAM command a few weeks back to list every shared drive and every member of the shared drive but I can't seem to remember how I did it, and I need to run it again. Have been trying for 20 minutes or so and can't figure it out again.

I know how to list the members of a single shared drive but how do I loop through every shared drive I have in the domain and list out everyone who has access to each shared drive. Ideally, the output would go to todrive, not csv, but csv is fine too. I'd like to get allfields that are available.

Thanks for any help. I'm using GAMADV-XTD3.

(keywords to help me find this post again one day: list all members of shared drive, list team drive members across all team drives, print all team drive members, every team drive member, every shared drive, every team drive)


Constantly Learning

unread,
Feb 22, 2020, 9:18:55 AM2/22/20
to GAM for G Suite
Oh and ideally this would also list any external members who are not in my domain...we occasionally share a team drive externally. Thanks!

Ian Crew

unread,
Feb 22, 2020, 10:24:19 AM2/22/20
to google-ap...@googlegroups.com

On Sat, Feb 22, 2020 at 6:19 AM Constantly Learning <k...@walkersands.com> wrote:
Oh and ideally this would also list any external members who are not in my domain...we occasionally share a team drive externally. 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-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e53b4d23-4f76-4a4f-bb9f-f93df6288ba1%40googlegroups.com.
--
___
Ian Crew

IST-Architecture, Platforms and Integration (API)
Earl Warren Hall, Second Floor
University of California, Berkeley

Ross Scroggs

unread,
Feb 22, 2020, 10:32:54 AM2/22/20
to google-ap...@googlegroups.com
On Feb 22, 2020, at 6:18 AM, Constantly Learning <k...@walkersands.com> wrote:

Oh and ideally this would also list any external members who are not in my domain...we occasionally share a team drive externally. Thanks!

Constantly Learning

unread,
Feb 22, 2020, 11:09:03 AM2/22/20
to GAM for G Suite
Thanks, Ross. I will try to figure it out from here and will post how it's done once and if I figure it out. Those are helpful resource pages. Wish I had the specific commands to run to list out  -- I know I had them a couple weeks ago to just quickly get a table like this: User id | name | role | backgroundImageLink | capabilities.canAddChildren etc.  Appreciate your help (and your work!) as always.

Ken


On Saturday, February 22, 2020 at 9:32:54 AM UTC-6, Ross Scroggs wrote:
On Feb 22, 2020, at 6:18 AM, Constantly Learning <k...@walkersands.com> wrote:

Oh and ideally this would also list any external members who are not in my domain...we occasionally share a team drive externally. 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.

Constantly Learning

unread,
Feb 22, 2020, 11:15:10 AM2/22/20
to GAM for G Suite
Just found the command I had used last time:

gam config auto_batch_min 1 redirect csv ./UsersTeamDrivesOrga2.csv multiprocess all users print teamdrives

Only downside is that it doesn't report any users that are not in my domain who have access to a shared drive.

Ross Scroggs

unread,
Feb 22, 2020, 11:15:48 AM2/22/20
to google-ap...@googlegroups.com
Ken,

This will give you one ACL per Team Drive per row.

gam redirect csv TDScopes.csv print teamdriveacls oneitemperrow

Ross

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/bf0a75f3-916c-4287-aee6-76cf6b7e03cb%40googlegroups.com.

Constantly Learning

unread,
Feb 22, 2020, 11:18:21 AM2/22/20
to GAM for G Suite
Or this works too (running it now) -- thanks, Ian!

gam all users print teamdrives todrive



On Saturday, February 22, 2020 at 8:16:51 AM UTC-6, Constantly Learning wrote:

Ross Scroggs

unread,
Feb 22, 2020, 11:23:31 AM2/22/20
to google-ap...@googlegroups.com
gam all users print teamdrives todrive
This command will show you the Team Drive info but not the access info.
It can be simplifed to: gam print teamdrives todrive

This will give you one ACL per Team Drive per row.
gam print teamdriveacls oneitemperrow todrive

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.

Constantly Learning

unread,
Feb 22, 2020, 11:26:59 AM2/22/20
to GAM for G Suite
And the winner is:

gam print teamdriveacls oneitemperrow todrive

This also gives the external users who have access to my domain's shared drives. Perfect.

Thanks tons!


On Saturday, February 22, 2020 at 8:16:51 AM UTC-6, Constantly Learning wrote:

roberto souza braga

unread,
May 28, 2024, 2:26:09 PM5/28/24
to GAM for Google Workspace
Hey Guys!

know its been a while this post is on, but im trying to do the exact same thing, already tried all you guys commands, but none seem to work nowadays... any clues on how to solve it?

Ross Scroggs

unread,
May 28, 2024, 2:34:58 PM5/28/24
to google-ap...@googlegroups.com
What is: gam version

Show an example of none seem to work

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/0b878e86-aa5a-4966-9ec7-a007b1afde5an%40googlegroups.com.


--

roberto souza braga

unread,
May 28, 2024, 2:56:35 PM5/28/24
to GAM for Google Workspace
Hey Ross, thanks for reaching out!

GAM Version is 6.58
image.png

Ross Scroggs

unread,
May 28, 2024, 3:03:24 PM5/28/24
to google-ap...@googlegroups.com
You have Standard GAM, Advanced GAM is required.


Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/fc66bf3a-0222-4868-ad23-6ae24844e72fn%40googlegroups.com.


--
Reply all
Reply to author
Forward
0 new messages