Delete Drive Files Before Date

[Jason Jones]

Hello! 

Is it possible to delete all drive files prior  to a certain date using GAM? 

I can find pieces, but can't get the whole picture. 

This would be for student OU's only, not a domain wide deletion. 

Thank you!

[Ross Scroggs]

Jason,

gam ou "/Students/OU" delete drivefile query "createdTime<'2020-01-01T00:00:00Z'" purge

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/951c13e1-ec59-4a7a-905e-26cfb523243an%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Jason Jones]

Hey Ross! Finally got some breathing room to mess with this, and have tried several changes and still get an error. Doing in a test OU with a test user.

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

gam ou "/Students/Withdrawals/test" delete drivefile query "createdTime<'2020-01-01T00:00:00Z'" purge
Getting all Users in Google Workspace account that match query (orgUnitPath='/Students/Withdrawals/test') (may take some time on a large account)...
Got 1 Users...
1 Users are directly in the OU.

ERROR: createdTime<'2020-01-01T00:00:00Z' is not a valid argument for "gam <users> delete drivefile"

[Ross Scroggs]

It looks like you're running Standard GAM, modify the command slightly; put a colon after query

gam ou "/Students/Withdrawals/test" delete drivefile query:"createdTime<'2020-01-01T00:00:00Z'" purge

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/d6e72184-6e16-4d1e-8d56-56c35790c053n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Jason Jones]

Hey Ross! I am getting ready to do family stuff. Any chance I can catch you tomorrow morning? 

I am getting a different error now with the change. Getting invalid query. 

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

gam ou "/Students/Withdrawals/test" delete drivefile query:"createdTime<'2020-01-01T00:00:00Z'" purge
Getting all Users in Google Workspace account that match query (orgUnitPath='/Students/Withdrawals/test') (may take some time on a large account)...
Got 1 Users...
1 Users are directly in the OU.

Searching for files with query: "createdTime<'2020-01-01T00:00:00Z'"...

ERROR: 400: Invalid query - invalid

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8m%2B7Jjmk0KB2JG90SWG4QyOJysX6nx-fcocz3PftJe1g%40mail.gmail.com.

--

Jason Jones Systems Engineer | Managed Services jjo...@five-startech.com | 812-246-5257 Five Star Technology Solutions 3310 E 10th St. Suite 4, #358 Jeffersonville, IN 47130 fivestartech.com

[Ross Scroggs]

Jason,

I'm available starting at 7:45AM PDT.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAEUm%2BZ5Ueh0f9_ACsKjwVs5goWO37%2Bc23G-JOBQf07CvMbLdgA%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

[Jason Komendat]

I was looking at doing something similiar. Just wonderting if anyone found thre right command for this.

[Jason Jones]

Hey Ross! Would you have time to discuss this sometime this week? Perhaps 1:00 EST 11/9 or 11/10?

[Jason Jones]

Using  gam ou "/Students/Withdrawals/test" delete drivefile query:"createdTime<'2020-01-01T00:00:00Z'" purge

It runs and gets the 1 user in that OU. 

Then I get "Searching for files with query: "createdTime<'2020-01-01T00:00:00Z'"...

ERROR: 400: Invalid query - invalid"

Any thoughts? 

[Omar Hamzeh]

Hi Ross
hope you're doing well 

Is it possible to Delete all files that don’t have a specific Label and haven’t been viewed in the last 6 months and before a specific creation date??

Regards