Trying to sort out a user's shared folder "tree"

118 views
Skip to first unread message

Richard Cooke

unread,
Apr 5, 2021, 11:35:36 AM4/5/21
to GAM for Google Workspace
I have a user that became (one of) the hosts of mostly company wide shared files and folders.  He based it off a folder in his My Drive. It was expected that all users in the company would be able to easily view/edit/add/modify most of these files.  Of course, this is not the case. They can "find" or "view" or download them.  But not edit in place or contribute new files.  Unless the "owner" manually adds them as editors. This created a lot of work for the owner, which is not being maintained well.  It seems like the new Shared Drives (originally Team Drives) is designed for this, with the added bonus of not tying ownership to a single user. We have already had some "fun" when a user left us, and they had some important files shared from their My Drive, and their account was deleted.  Before my time, but I'm told it was 'not fun' to round up the missing files and get them back online.

So I WAS going to just have the owner move the whole tree into a new Shared Drive folder.

However, there is a complication.  Some of the sub-folders are meant for a smaller sub-audience of users than the rest.  So I need to ferret out these folders/files first and move them to their OWN shared folder with the sub-user list. After that, the remaining files can go to the new "Company Wide Shared Drive". whew.

But Its not obvious to me how to do this.  I ran this command on all users:
gam user sa...@north.pole.ca show filelist todrive allfields

My first attempt I tried the all user syntax, but that blew up. Apparently some users have an impressive number of My Drive files/folders.

So I made a shell script to do each user one at a time.  10 or so users still bombed.  One being the "master owner" of the company shared folder.  So I dropped the "allfields" and "todrive" flags as required to get a report for them.

Actually, I think I got the allfields flag to work for the special user, because the CSV file lists all the shares (share0 to share21).

Browsing the file, there does not seem to be an obvious pattern to the share names.  Sometimes a user will be listed as "share0", then later "share5".  So sorting by share0 column wont give me a magic list to tell who has access to what.

And I don't see the PATH to any of the files!  Just the file name and extension.  

Is there a better way, or an option I missed to sort this out?

Thanks in advance!



Reply all
Reply to author
Forward
0 new messages