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

[giveen]

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]

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]

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]

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 <#239 (comment)>, 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]

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]

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 <#239 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACCTYL6CCOMB53D4N2TMIBLVECEZPANCNFSM5N675ANA>. You are receiving this because you commented.