GAM Report for Trashed Files

598 views
Skip to first unread message

Brandon Viertel

unread,
Nov 8, 2022, 11:06:46 AM11/8/22
to GAM for Google Workspace
We have a very large instance, with 500TB+ of storage used. Is there any way to get a per user report on the files and storage used in the trash? Or trash as a whole? I know I can run a command per user to print all files in a user's Drive, and list the Trashed status, but would like to have a per user across all users overview of the files in the trash instead of the firehose of information per file. We are using this information to watch the user activity for a cleanup project underway, allowing users to manage their own cleanup before we go in. 

Thanks!

Brandon 

Jay Lee

unread,
Nov 8, 2022, 11:34:23 AM11/8/22
to google-ap...@googlegroups.com
gam report user todrive

includes numerous fields for trash item count but not used quota for those trashed items. Still it gives you something to watch.

It's also worth calling out that Drive Trash now auto-expunges items after 30 days so some of the cleanup happens on it's own.


Jay

--
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/2a34b88d-ec98-421b-b9d0-5ac13fb57accn%40googlegroups.com.

Jay Lee

unread,
Nov 8, 2022, 11:40:42 AM11/8/22
to google-ap...@googlegroups.com
Oops... Accidentally posted from my secret identity. Now my cover is blown.

Jay

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAKsvYM7kSUY6T%3D%3DZqa9M87QVLjQdL8aDfPUTETxKPwZndivn%2Bg%40mail.gmail.com.

Ross Scroggs

unread,
Nov 8, 2022, 1:51:36 PM11/8/22
to google-ap...@googlegroups.com
Brandon,

Send me a Meet/Zoom invitation, I think that I can get what you want.

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/2a34b88d-ec98-421b-b9d0-5ac13fb57accn%40googlegroups.com.


--

Ross Scroggs

unread,
Nov 8, 2022, 2:33:09 PM11/8/22
to google-ap...@googlegroups.com
Brandon,

With Advanced GAM, try this:

gam redirect csv ./FileCountSize.csv all users print filecounts query "trashed=true" showsize summary plus


Replace all users with ou "/Path/To/OU" to test.


Ross


On Tue, Nov 8, 2022 at 8:06 AM 'Brandon Viertel' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:
--
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/2a34b88d-ec98-421b-b9d0-5ac13fb57accn%40googlegroups.com.


--
Reply all
Reply to author
Forward
0 new messages