Team drive and gam

Rick Humphrey

unread,

Jun 16, 2018, 11:47:26 AM6/16/18

to GAM for G Suite

Is there a gam command to output a list of all the team drives in your domain, list all the members of each team drive,show the privilege level of each member and then output that to a csv file.

Thanks

Ross Scroggs

unread,

Jun 16, 2018, 8:59:04 PM6/16/18

to google-ap...@googlegroups.com

Rick,

There is with my Advanced GAM for Team Drives (https://github.com/taers232c/GAMADV-XTD)

$ gam redirect csv ./teamdrives.csv print teamdrives

This gives one row per Team Drive with all privileges on that row.
$ gam redirect csv ./teamdriveacls.csv multiprocess csv ./teamdrives.csv gam print drivefileacls teamdriveid ~id

This gives one row per Team Drive per privilege.

$ gam redirect csv ./teamdriveacls.csv multiprocess csv ./teamdrives.csv gam print drivefileacls teamdriveid ~id oneitemperrow

You'll have to merge the Team Drive name column from teamdrives.csv into teamdriveacls.csv

Ross

--

ross.s...@gmail.com

On Jun 16, 2018, at 8:47 AM, Rick Humphrey <rick.h...@wolfcreek.ab.ca> wrote:

Is there a gam command to output a list of all the team drives in your domain, list all the members of each team drive,show the privilege level of each member and then output that to a csv file.

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 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/8477d581-b16e-4552-968e-42d015bda514%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ross Scroggs

unread,

Jun 16, 2018, 9:08:12 PM6/16/18

to google-ap...@googlegroups.com

Rick,

I fell asleep, there is single command to do what you want, it includes the Team Drive name; again, you can get all privileges on one row per Team Drive or one privilege per Team Drive per row.

gam redirect csv ./teamdriveacls.csv print teamdriveacls

gam redirect csv ./teamdriveacls.csv print teamdriveacls oneitemperrow

Ross

--

ross.s...@gmail.com

On Jun 16, 2018, at 8:47 AM, Rick Humphrey <rick.h...@wolfcreek.ab.ca> wrote:

Is there a gam command to output a list of all the team drives in your domain, list all the members of each team drive,show the privilege level of each member and then output that to a csv file.

Thanks

Rick Humphrey

unread,

Jun 19, 2018, 11:19:51 PM6/19/18

to google-ap...@googlegroups.com

Thank you for this

Rick

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/8EBCE32A-1401-482A-90BC-B3EBDDF98C5B%40gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Rick Humphrey

Wolf Creek Public Schools

Technology Services

403-783-5441 ext 1427

Thanapol Prasertsak

unread,

Jan 7, 2019, 3:20:15 AM1/7/19

to GAM for G Suite

Hi Ross Scroggs,

I am looking for the output of member exporting in Teamdrive and think that your scripts are very useful.

However, I have some errors when executing the suggested scripts. It would be appreciated that you can guide how to solve with them.

c:\GAMADV-X>gam redirect csv ./TeamDrives.csv print teamdriveacls

Command: gam redirect csv ./TeamDrives.csv print >>>teamdriveacls<<<

Help: Syntax in file c:\GAMADV-X\GamCommands.txt

Help: Documentation is at https://github.com/taers232c/GAMADV-X/wiki

Thank in advanced.

Thanapol

Ross Scroggs

unread,

Jan 7, 2019, 9:23:50 AM1/7/19

to google-ap...@googlegroups.com

Thanapol,

You need GAMADV-XTD (https://github.com/taers232c/GAMADV-XTD). It is a superset of GAMADV-X with full Team Drive support.

Ross

--

ross.s...@gmail.com

--
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/dd329a6c-e689-4318-af14-4c2769fff094%40googlegroups.com.

Thanapol Prasertsak

unread,

Jan 9, 2019, 9:58:11 PM1/9/19

to GAM for G Suite

Thanks alot for your guidance.

On Monday, January 7, 2019 at 9:23:50 PM UTC+7, Ross Scroggs wrote:

Thanapol,

You need GAMADV-XTD (https://github.com/taers232c/GAMADV-XTD). It is a superset of GAMADV-X with full Team Drive support.

Ross

--
ross.s...@gmail.com

On Jan 6, 2019, at 10:14 PM, 'Thanapol Prasertsak' via GAM for G Suite <google-ap...@googlegroups.com> wrote:

Hi Ross Scroggs,

I am looking for the output of member exporting in Teamdrive and think that your scripts are very useful.

However, I have some errors when executing the suggested scripts. It would be appreciated that you can guide how to solve with them.

c:\GAMADV-X>gam redirect csv ./TeamDrives.csv print teamdriveacls
Command: gam redirect csv ./TeamDrives.csv print >>>teamdriveacls<<<

ERROR: Invalid argument: Expected <admin|adminroles|alias|building|classroominvitation|contact|course|courseannouncements|courseparticipants|courses|coursesubmissions|coursework|cros|crosactivity|datatransfer|domain|domainalias|feature|gal|group|groupmembers|guardian|license|mobile|org|orgs|ownership|printer|printjobs|privileges|resoldsubscription|resource|resources|schema|site|siteacl|siteactivity|token|transferapps|user|users|vaultexport|vaulthold|vaultmatter>
Help: Syntax in file c:\GAMADV-X\GamCommands.txt
Help: Documentation is at https://github.com/taers232c/GAMADV-X/wiki

Thank in advanced.
Thanapol

--
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.

Kit Gillingham

unread,

Jan 25, 2019, 4:53:32 AM1/25/19

to google-apps-manager

Hi Ross,

I'm getting the same error when trying to get the group members.

Is there a way to report on a specific group? We are a large org with 1000's of groups and members. Thanks

Error:

c:\GAMADV-X>gam redirect csv ./teamdriveacls.csv print teamdriveacls oneitemperrow

Command: gam redirect csv ./teamdriveacls.csv print >>>teamdriveacls<<< oneitemperrow

Help: Syntax in file c:\GAMADV-X\GamCommands.txt

Help: Documentation is at https://github.com/taers232c/GAMADV-X/wiki

Regards

Kit Gillingham
IT Support

Click here to access the IT Service Centre online: IT Service Centre

Click here to access the Self Service Portal: Self Service

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/A865A7AB-6EB7-4049-AEFB-E8A6649CE8D3%40gmail.com.

Ross Scroggs

unread,

Jan 25, 2019, 7:19:05 AM1/25/19

to google-ap...@googlegroups.com

Kit,

You need GAMADV-XTD (https://github.com/taers232c/GAMADV-XTD). It is a superset of GAMADV-X with full Team Drive support.

Ross

--

ross.s...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAP%2BcF7xNkcadOPOaQnBq-1w2X2vJaSV4T2aELL7CMV%2BJ4T6sZg%40mail.gmail.com.

Kit Gillingham

unread,

Jan 25, 2019, 11:21:32 AM1/25/19

to google-apps-manager

😱

So sorry Ross, I didn't see that it was a different version of GAM ADV

Thank you,

Regards

Kit Gillingham
IT Support

Click here to access the IT Service Centre online: IT Service Centre

Click here to access the Self Service Portal: Self Service

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/226EF074-BF63-4335-BEA4-7E81822962E3%40gmail.com.

Ross Scroggs

unread,

Jan 25, 2019, 11:27:57 AM1/25/19

to google-ap...@googlegroups.com

Kit,

You can just replace GAMADV-X with GAMADV-XTD; same gam.cfg, same authorization files.

It adds Team Drive support.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAP%2BcF7zTkgUjFuoP%2BocHK4PomzFDE52uok%3DePOeDM2jPxjtsow%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Ross Scroggs

ross.s...@gmail.com

Reply all

Reply to author

Forward