permissions.x.emailAddress - ONLY show external emails with access to each file

93 views
Skip to first unread message

KSD

unread,
Feb 7, 2023, 11:28:19 AM2/7/23
to GAM for Google Workspace

Hello,

My current GAM version is: 6.27.11

I'm having difficulty in creating a report that will show all files that are being shared with someone external to the domain (let's call this domain "test.com"), but I need to EXCLUDE any internal permissions for those files in the report. I'm getting a report from the command below, but each file listed includes all of the internal permissions too, making the CSV extremely large.

Perhaps I misunderstand the limits of this kind of report, or maybe I'm just using the wrong command? Is using one of the Python scripts going to be absolutely necessary to get the report I'm after?

Below is what I've tried as if "test.com" was my domain:

gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,title,permissions,owners.emailaddress,mimetype pm not domain test.com em

Ross Scroggs

unread,
Feb 7, 2023, 1:49:50 PM2/7/23
to google-ap...@googlegroups.com
KSD, 

The ps not domain.com em just selects the files, it does not limit the acls


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/6b4d71bc-8f46-4f35-b85d-79f935195d92n%40googlegroups.com.


--

KSD

unread,
Feb 10, 2023, 7:16:53 PM2/10/23
to GAM for Google Workspace
Thanks Ross,

I got it working.

Ross Scroggs

unread,
Feb 10, 2023, 7:25:35 PM2/10/23
to google-ap...@googlegroups.com
As of 6.32.01 you can say the following ad get the data with one command.

gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,title,permissions,owners.emailaddress,mimetype pm not domain test.com em pmfilter oneitemperrow


Ross





--

KSD

unread,
Mar 13, 2023, 10:41:49 AM3/13/23
to GAM for Google Workspace
Ross, excellent addition. Is there something like this for querying files that are shared externally from Shared Drives? I've been trying to use this script GetSharedExternallyTeamDriveACLs.py, but for some reason it seems to only pick out one Shared Drive to query the desired results for.
Reply all
Reply to author
Forward
0 new messages