Visible To Anyone With Link

[RBL]

The UserUsageReport shows a category of files called "Visible To Anyone With Link".

I am looking to get a list of these files in google drive so I can review them.

I couldn't find the proper search term in google drive's api:

https://developers.google.com/drive/web/search-parameters

I also couldn't seem to find anything that would provide this list searching for file permissions commands.

Any help on this would be appreciated.

-RBL

[RBL]

To summarize the question, is there a way to create a list of links to files in google drive, that any user in my organization posted as Visible to Anyone With Link.

[Alastair Pott]

EDIT: Should have been 

gam all users show filelist shared id | grep -vw "False" > allSharedFiles.csv

OR

gam all users show filelist shared id | grep -w "True" > allSharedFiles.csv

[Alastair Pott]

Have been trying to do exactly the same but not had much luck, so would def also be interested in a solution if anyone has any ideas.

At best so far, I can check manually one by for each file:

gam all users show filelist shared id | grep -vw "True" > allSharedFiles.csv

Can then manually select each id and run

gam user [email address] show drivefileacl [id]

then check if it contains a line with id: anyoneWithLink

Not ideal, especially with nearly 60,000 lines in the allSharedFiles.csv

Tried to run it as a bulk operation with

gam csv AllSharedFiles.csv gam user ~Owner show drivefileacl ~id

with the idea of finding a way later to reduce to only the info required, but having an issue now with

_csv.Error: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

Thrown in the towel for now, might look again in the morning, but I'm sure someone much smarter would be able to figure out a way to do it :P

Cheers,

Al

On Tuesday, 25 August 2015 22:31:33 UTC+1, RBL wrote: