Listing all shared files in Google Workspace?

169 views
Skip to first unread message

BCNCOM

unread,
Jun 20, 2024, 10:50:52 AM6/20/24
to GAM for Google Workspace
I assume there's a GAM/GAMadv script to do this; we've got clients who are looking to list all shared files in their Google Workspace tenant. We don't need date/timestamps; just a list of each file.

Is this possible?

Ross Scroggs

unread,
Jun 20, 2024, 10:56:06 AM6/20/24
to google-ap...@googlegroups.com
Shared how? Internally/externally? Do they want to to see the entities to which the file is shared or just that the file is shared?

Roasas
----
Ross Scroggs



On Jun 20, 2024, at 7:50 AM, 'BCNCOM' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

I assume there's a GAM/GAMadv script to do this; we've got clients who are looking to list all shared files in their Google Workspace tenant. We don't need date/timestamps; just a list of each file.

Is this possible?

--
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/2207831a-d0de-41ef-a05d-95fca895fb69n%40googlegroups.com.

Brian Cross

unread,
Jun 20, 2024, 11:13:37 AM6/20/24
to google-ap...@googlegroups.com
Both internal and external, and it looks like (for now) that just that the file is shared.

Brian Cross
Support Tech Level 2

E bcr...@nutmegit.com

P (860) 256-4822 x714

---------------------------------------------------------------------------------------------

On the Web: Nutmegit.com | Facebook | Linkedin

Featured Solutions:
LightSwitch - Lighting the Way to Better Network Management
HMIS Consulting – Experienced HMIS Consulting and Professional Services



On Thu, Jun 20, 2024 at 10:56 AM Ross Scroggs <ross.s...@gmail.com> wrote:
Shared how? Internally/externally? Do they want to to see the entities to which the file is shared or just that the file is shared? Roasas ---- Ross Scroggs Ross.S...@gmail.com On Jun 20, 2024, at
sophospsmartbannerend
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/tof3Q-znsJQ/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/78F2D2B6-4CC0-41FC-88F8-D8C30FF50677%40gmail.com.

Ross Scroggs

unread,
Jun 20, 2024, 11:39:15 AM6/20/24
to google-ap...@googlegroups.com
Advanced GAM:

This wiil give one row per shared file, no sharing permissions are shown
gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,name,mimetype pm not role owner em pmfilter

This wiil give one row per shared file, all sharing permissions on that row
gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,name,mimetype,basicpermissions pm not role owner em pmfilter

This wiil give one row per shared file/permission combination
gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,name,mimetype,basicpermissions pm not role owner em pmfilter oneitemperrow

Ross
----
Ross Scroggs



Brian Cross

unread,
Jun 20, 2024, 12:12:08 PM6/20/24
to google-ap...@googlegroups.com
Excellent, thanks as always, Ross!

Brian Cross
Support Tech Level 2

E bcr...@nutmegit.com

P (860) 256-4822 x714

---------------------------------------------------------------------------------------------

On the Web: Nutmegit.com | Facebook | Linkedin

Featured Solutions:
LightSwitch - Lighting the Way to Better Network Management
HMIS Consulting – Experienced HMIS Consulting and Professional Services


On Thu, Jun 20, 2024 at 11:39 AM Ross Scroggs <ross.s...@gmail.com> wrote:
Advanced GAM: This wiil give one row per shared file, no sharing permissions are shown gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,name
sophospsmartbannerend

BCNCOM

unread,
Jul 9, 2024, 9:06:26 AM7/9/24
to GAM for Google Workspace
Hey Ross, got a quick followup on this:

What other fields of information can we get about these permissions? Date/time created? Modified? Who shared the file? Then we are looking to create a script to delete permissions (or disable them) by their date. Is that possible with GAM advanced?

Ross Scroggs

unread,
Jul 9, 2024, 10:21:02 AM7/9/24
to google-ap...@googlegroups.com
Brian,

Here is the API documentation on the fields available for permissions:

None of the fields you mention are available.

Ross
----
Ross Scroggs


Brian Cross

unread,
Jul 9, 2024, 11:49:13 AM7/9/24
to google-ap...@googlegroups.com
Thank you sir, much appreciated!

Brian Cross
Support Tech Level 2

E bcr...@nutmegit.com

P (860) 256-4822 x714

---------------------------------------------------------------------------------------------

On the Web: Nutmegit.com | Facebook | Linkedin

Featured Solutions:
LightSwitch - Lighting the Way to Better Network Management
HMIS Consulting – Experienced HMIS Consulting and Professional Services


On Tue, Jul 9, 2024 at 10:21 AM Ross Scroggs <ross.s...@gmail.com> wrote:
Brian, Here is the API documentation on the fields available for permissions: https://developers.google.com/drive/api/reference/rest/v3/permissions None of the fields you mention are available. Ross -
sophospsmartbannerend
Reply all
Reply to author
Forward
0 new messages