search

taers232c / GAMADV-XTD3

Command line tool to manage Google Workspace
714 stars 87 forks source link

List contents of drive for all users - output to same sheet #239

Closed giveen closed 2 years ago

giveen commented 2 years ago

I am trying to look for all video files over a certain size in Google drive and output them all to the same Google Sheet. The problem i am having is its opening up thousands of Google Sheets and crashing my machine.

C:\gam\gam.exe all users show filelist corpora alldrives fields title,filesize,id query "mimeType contains 'video/'" minimumfilesize 250000000 todrive tdtitle Student-Videos

taers232c commented 2 years ago

Send me a Meet/Zoom invitation.

gam version
gam config verify
what  is the value of auto_batch_min?

C:\gam\gam.exe config auto_batch_min 1 redirect csv - multiprocess todrive tdtitle Student-Videos all users show filelist corpora alldrives fields title,filesize,id query "mimeType contains 'video/'" minimumfilesize 250000000

ross.scroggs @ gmail.com

giveen commented 2 years ago

Send me a Meet/Zoom invitation.

gam version gam config verify what is the value of auto_batch_min?

C:\gam\gam.exe config auto_batch_min 1 redirect csv - multiprocess todrive tdtitle Student-Videos all users show filelist corpora alldrives fields title,filesize,id query "mimeType contains 'video/'" minimumfilesize 250000000

ross.scroggs @ gmail.com

I'll try to hit you up tomorrow. I have to sign documents for closing on a house and I'm going on paternity leave so I wont be allowed to touch work stuff.

taers232c commented 2 years ago

I'm in California (PST) and will be available after 8:00 AM PST.

Ross

On Wed, Feb 9, 2022 at 5:11 PM Giveen @.***> wrote:

Send me a Meet/Zoom invitation.

gam version gam config verify what is the value of auto_batch_min?

C:\gam\gam.exe config auto_batch_min 1 redirect csv - multiprocess todrive tdtitle Student-Videos all users show filelist corpora alldrives fields title,filesize,id query "mimeType contains 'video/'" minimumfilesize 250000000

ross.scroggs @ gmail.com

I'll try to hit you up tomorrow. I have to sign documents for closing on a house and I'm going on paternity leave so I wont be allowed to touch work stuff.

— Reply to this email directly, view it on GitHub https://github.com/taers232c/GAMADV-XTD3/issues/239#issuecomment-1034379560, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACCTYL76CEPP7SB7WFBH5RDU2MGFJANCNFSM5N675ANA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you commented.Message ID: @.***>

-- Ross Scroggs @.***

giveen commented 2 years ago

Resolved by just putting to local csv file.

C:\gam\gam.exe redirect csv "c:\temp\studentvideos2.csv" multiprocess all users show filelist corpora alldrives fields title,filesize,id query "mimeType contains 'video/'" minimumfilesize 150000000

taers232c commented 2 years ago

This should work:

C:\gam\gam.exe redirect csv "c:\temp\studentvideos2.csv" multiprocess todrive tdtitle "Student-Videos2" all users show filelist corpora alldrives fields title,filesize,id query "mimeType contains 'video/'" minimumfilesize 150000000

Ross

-- @.***

On Apr 8, 2022, at 12:50 PM, Giveen @.***> wrote:

Resolved by just putting to local csv file.

C:\gam\gam.exe redirect csv "c:\temp\studentvideos2.csv" multiprocess all users show filelist corpora alldrives fields title,filesize,id query "mimeType contains 'video/'" minimumfilesize 150000000

— Reply to this email directly, view it on GitHub https://github.com/taers232c/GAMADV-XTD3/issues/239#issuecomment-1093300319, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACCTYL6CCOMB53D4N2TMIBLVECEZPANCNFSM5N675ANA. You are receiving this because you commented.