Having trouble with 'print filelist' command
19 views
Skip to first unread message
Tyler Fish
Apr 24, 2026, 10:36:18 AM (3 days ago) Apr 24
to GAM for Google Workspace
Found a command recommendation while looking through forums that should give a list of users with videos in their Google drive that are over 500mb and display it in a Google Sheet. The issue I'm running into with it is that for every user it says
Getting all Drive Files/Folders that match query ('me' in owners and (mimetype contains 'video')) for UsersName
as well as
Drive File/Folder Print Failed: Query ('me' in owners and (mimetype contains 'video')) Invalid
It will also open a blank Google Sheet for each user and tank my computer performance. Below is the exact command used. Any help will be greatly appreciated!
gam ou_and_children '/Path/to/ou' print filelist minimumfilesize 524288000
query "mimeType contains 'video'" title id size todrive tdtitle "Student
Drive Report"
Tyler Fish
"This message and any attachment constitute a PRIVATE and CONFIDENTIAL communication and may contain legally privileged information. Do not share any information from this communication with any one unless you have received permission from the sender. If you are not the intended recipient, further distribution or use of these items is prohibited. In that case, do not read, copy or use the information contained herein or disclose it to others. Please notify the sender of the delivery error by replying to this message and then delete it from your system."
Getting all Drive Files/Folders that match query ('me' in owners and (mimetype contains 'video')) for UsersName
as well as
Drive File/Folder Print Failed: Query ('me' in owners and (mimetype contains 'video')) Invalid
It will also open a blank Google Sheet for each user and tank my computer performance. Below is the exact command used. Any help will be greatly appreciated!
gam ou_and_children '/Path/to/ou' print filelist minimumfilesize 524288000
query "mimeType contains 'video'" title id size todrive tdtitle "Student
Drive Report"
Tyler Fish
"This message and any attachment constitute a PRIVATE and CONFIDENTIAL communication and may contain legally privileged information. Do not share any information from this communication with any one unless you have received permission from the sender. If you are not the intended recipient, further distribution or use of these items is prohibited. In that case, do not read, copy or use the information contained herein or disclose it to others. Please notify the sender of the delivery error by replying to this message and then delete it from your system."
Ross Scroggs
Apr 24, 2026, 10:44:13 AM (3 days ago) Apr 24
to google-ap...@googlegroups.com
You command shows: query "mimeType contains 'video'"
The getting message shows: (mimetype contains 'video')) (notice the lowercase t)
What is: gam version
Sen me a private Meet/Zoom invitation and I'll help
--
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 visit https://groups.google.com/d/msgid/google-apps-manager/2fd3b167-ed1a-4dbd-98fb-bfc25469c045n%40googlegroups.com.
Tyler Fish
Apr 24, 2026, 10:49:23 AM (3 days ago) Apr 24
to GAM for Google Workspace
I am on the latest version. Just sent a Google Meet invite over.
Thank you!
Thank you!
Reply all
Reply to author
Forward
0 new messages