Google Sites in Google Shared Drives

21 views
Skip to first unread message

Bryan Riley

unread,
Nov 20, 2025, 9:37:13 AM (2 days ago) Nov 20
to GAM for Google Workspace
Does anyone know if there is a GAM command to query and find all Google Sites that are stored in Google Shared Drives? I ran the following command but it only displays Google Sites stored in users My Drive.

GAM Command:
gam config auto_batch_min 1 num_threads 10 redirect csv ./GoogleSites.csv multiprocess redirect stderr - multiprocess all users print filelist allfields pm not role owner em oneitemperrow pmfilter showmimetype gsite

Ross Scroggs

unread,
Nov 20, 2025, 10:52:17 AM (2 days ago) Nov 20
to google-ap...@googlegroups.com
gam redirect csv ./SharedDriveOrganizers.csv print shareddriveorganizers

gam config num_threads 10 redirect csv ./SharedDriveGoogleSites.csv multiprocess redirect stderr - multiprocess csv SharedDriveOrganizers.csv gam user "~organizers"  print filelist select teamdriveid "~id" fields id,driveid,name,mimetype,basicpermissions showdrivename showmimetype gsite fullpath inherited false em pmfilter oneitemperrow

allfields is a lot of data.

What is the purpose here: pm not role owner em oneitemperrow pmfilter


Ross

----
Ross Scroggs



Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains.

--
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 visit https://groups.google.com/d/msgid/google-apps-manager/1ff18417-bcee-44b2-a83b-b22be8e9444bn%40googlegroups.com.

Bryan Riley

unread,
Nov 20, 2025, 1:50:15 PM (2 days ago) Nov 20
to GAM for Google Workspace
I wasn't 100% sure on field names that's why I listed allfields.

I'm trying to run your second command after identifying all of our SD organizers but I'm getting an error that I don't know how to decode :)..Any suggestions??
GAMError.png

Ross Scroggs

unread,
Nov 20, 2025, 1:59:46 PM (2 days ago) Nov 20
to google-ap...@googlegroups.com
... csv SharedDriveOrganizers.csv charset latin1 ...

Send me a private Meet/Zoom invitation

Ross
----
Ross Scroggs


Bryan Riley

unread,
Nov 21, 2025, 9:47:48 AM (22 hours ago) Nov 21
to google-ap...@googlegroups.com
Good Morning Ross,

The command we worked on to pull Google Shared Drive files and size appears to be working as intended.

However, the original command to pull Shared Drive organizers is not consistently identifying drive managers. Out of our 6,599 Shared Drives, 3,994 are being returned without an organizer or manager listed. While I initially suspected a major cleanup was needed, a closer review shows that some of these drives do, in fact, have a listed manager.

I have run the command a second time and on a separate device, but the results remain the same.

Do you have any thoughts on why this might be happening? 

The command I ran is:
gam redirect csv ./SharedDriveOrganizers.csv print shareddriveorganizers

Thanks,

Bryan Riley | Supervisor, Google Support and MDM | Community Health Systems
4000 Meridian Blvd. | Franklin, TN 37067 | Ph: 629.235.9673 | Fax: 615.628.6934 | www.chs.net

Are you looking for training, feature updates, or KBs on Google Workspace? Check out the new Google Workspace Resource Site



External to CHS, click here to see my availability to meet.





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/l0FSVoZw-nM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/6A144C51-D694-42BA-943E-D8D0CC6E71BC%40gmail.com.

Ross Scroggs

unread,
Nov 21, 2025, 10:14:54 AM (22 hours ago) Nov 21
to google-ap...@googlegroups.com
See: https://github.com/GAM-team/GAM/wiki/Shared-Drives#display-shared-drive-organizers

By default, only organizers from your primary domain are selected.

To select organizers from any domain, use: domainlist ""


Ross

----
Ross Scroggs


Bryan Riley

unread,
Nov 21, 2025, 4:53:26 PM (15 hours ago) Nov 21
to google-ap...@googlegroups.com
Thanks again Ross, that did the trick. Have a great weekend!!!
Reply all
Reply to author
Forward
0 new messages