Filelist for users not including all externally-owned files

[Chris Tucker]

I'm printing filelists of our users, but finding that it's not always printing all externally-owned files to the csv. For example, I know that UserA has files in subfolders in their My Drives that are owned externally. When running "gam user <user> print filelist fields id title permissions owners filepath parents mimetype showownedby any excludetrashed todrive", some of these files are not included. I know the files are in My Drive > Folder1 > Folder2 > Folder3, and if I add "select <folderID of Folder1, Folder2, or Folder3>", the known external files are included. I thought maybe as a workaround I could try selecting the id of the user's My Drive folder, but nothing happens after submitting that command (it just sits there like it has accepted the command but doesn’t progress and I have to abort it). I also tried replacing the “select” and "showownedby any" parameters with "choose mydrive_any", but those known external files were still excluded. All of the sub folders have the same owner as the My Drive. This particular My Drive has a lot of archived users' data (300543 files, to be exact). Unfortunately I don’t know of a smaller My Drive with this issue to test.

 

I'm struggling to figure out why these particular files are being excluded from the filelist, or how to obtain a filelist that includes them. I'm currently on gamadv-xtd3 v6.03.17, but noticed it on v6.00.02 as well.

[Kim Nilsson]

A little simpler/short filelist commands are often used to find all files and see who owns them.

Maybe you don't need all the options you have and still get the info. Try it and see what happens.

# GAMADV-XTD3: gam user test...@domain.com print filelist fields id,title,permissions,owners.emailaddress > filelistperms.csv

# GAM: gam user test...@domain.com print filelist id title permissions owners > filelistperms.csv