Getting files shared with External accounts in Shared drives and mydrive

[Aleksejs Sitdikovs]

Hello, 
Is it possible to get files and folders, which were shared with external email addresses in shared drives and my drive?
First task is to find out and second is to delete user from files/folders ACL. 

I tried to run this command: 

gam user ad...@domain.com print filelist fields id,name,driveid corpora alldrives query "'exte...@domain.com' in writers or 'external.com" todrive tdtitle "external.com External and MyDrive"

But it only find files in shared drive ( my admin account is manager of all shared drives). Despite the flad "corpora alldrives" it is not checking all drives. Am I missing something or it is not possible by design?

Thank you,

Cheers

[Ross Scroggs]

You will have to find the shares for each user's My Drive by running a command for each user.

See: https://github.com/taers232c/GAM-Scripts3/blob/master/GetSharedWithUserDriveACLs.py

The query does not look correct.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
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/6cd2362b-fe8e-47e2-b1ea-ba5397c0d4e3n%40googlegroups.com.

[Aleksejs Sitdikovs]

Hello Ross,

This script will search only "My drive" or MyDrive and Shared drive?
Or for Shared drive I need additional script?

Cheers,

Alex

[Ross Scroggs]

See: https://github.com/taers232c/GAM-Scripts3/blob/master/GetSharedWithUserTeamDriveACLs.py

Read the comments at the top of the scripts.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/c8046931-1ebf-45cd-bc4f-077f7b457502n%40googlegroups.com.

[Aleksejs Sitdikovs]

Hello Ross,

thank you for the script. After taking some time to understand how it works, I got strange behaviour.
When I run this command: 

gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,title,permissions,owners.emailaddress,mimetype pm type user notrole owner em pmfilter

It creates csv file and some emails addresses are capilased, which makes problem when I run this python script to create csv to delete ACLs, as name.s...@external.com doesn't produce anything, but Name.S...@external.com does does create.

Question is, is it possible from the first command: gam config auto_batch... to create a csv file with all emails in ACLs with lower case? Or what options are available to optimise the script, so it would be able to match strings.

Cheers,

Aleksejs

[T. Nguyen]

Hello Aleksejs,

I'm also having the same problem, I wonder if you have any solution for this

[Ross Scroggs]

In the script, change these two lines:

      emailAddress = row[f'permissions.{permissions_N}.emailAddress']

      domain = row[f'permissions.{permissions_N}.domain']

to:

      emailAddress = row[f'permissions.{permissions_N}.emailAddress'].lower()

      domain = row[f'permissions.{permissions_N}.domain'].lower()

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/4bd3c4f3-087d-4c88-8cb5-9c67ee7c8d96n%40googlegroups.com.

[Aleksejs Sitdikovs]

Thank you Ross, that did work.

I ended up not using the script for Shared Drives(Team drive), as for some reason it was not returning all users, which match criteria from csv file to new deleteperms.csv.
Manually searching them in filelistperms.csv I was able to find them, but not in deleteperms.csv for some reason. 

And It was taking way to long, to create csv file with all the permission, so I ended up not using it.
Instead I ended up using:
To create list for shared drives:
gam user share-dr...@domain.com print filelist fields id,name,driveid corpora alldrives query "'exte...@domain.com' in writers or 'exte...@domain.com' in readers" | gam csv - gam user "~Owner" delete drivefileacl "~id" exte...@domain.com todrive tdtitle "File name" And to find and delete: 

gam user share-dr...@domain.com print filelist fields id,name,driveid corpora alldrives query "'exte...@domain.com' in writers or 'exte...@domain.com' in readers" | gam csv - gam user "~Owner" delete drivefileacl "~id" exte...@domain.com

This works much faster. Thank you for your assistance. Have a great day.

[Nahuel Rodríguez]

Hello everyone. 
I'm new to GAM and trying to run this command:

gam config auto_batch_min 1 num_threads 20 redirect csv multiprocess todrive all users print filelist fields id,name,title,mimetype,owners.emailaddress,permissions pm not domain <domain.com> em pmfilter oneitemperrow

but I'm getting 

ERROR: config is not a valid argument for "gam"

Could you please give any hint on what I might be failing at?

Thanks!

[Ross Scroggs]

You're running Standard GAM, the command is for Advanced GAM.

See: https://github.com/taers232c/GAMADV-XTD3/wiki/How-to-Upgrade-from-Standard-GAM

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/0cfe4332-94b6-499b-be74-8827679c4bd2n%40googlegroups.com.

[Nahuel Rodríguez]

Yep, just figured it out. Such a newbie. Thanks!

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/J5g8lFvUqtg/unsubscribe.
To unsubscribe from this group and all its topics, 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/99DE739D-FEC1-4158-A699-C59EC408F7B3%40gmail.com.

--

Nahuel Rodriguez | IT Engineer e: nahuel.r...@belvo.com www.belvo.com