Print all files owned by User1 but not shared with anyone else

[Michael Cullers]

Good afternoon all! Trying to find a GAM command that will print a list of files owned by a user, but not shared with any other users or groups. Ideally it would also show the last time the file was viewed or modified. TIA

[Ross Scroggs]

Try this:

gam redirect csv ./Non_Shared_files.csv user us...@domain.com print filelist fields id,name,mimetype,modifiedtime,viewedbymetime pm not role owner em pmfilter pma skip 

See: https://github.com/GAM-team/GAM/wiki/Permission-Matches

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Feb 17, 2026, at 1:01 PM, 'Michael Cullers' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

Good afternoon all! Trying to find a GAM command that will print a list of files owned by a user, but not shared with any other users or groups. Ideally it would also show the last time the file was viewed or modified. TIA

--
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/3637ea25-dfc7-499a-b9bf-0decda543e74n%40googlegroups.com.

[Michael Cullers]

Ross, you are awesome! It works like a charm. We school tech people really appreciate you and your tools that make our life easier!

[Joseph Vaughan]

Agree with Michael in his praise for you, Ross. 

Quick question regarding the fields in the command you suggested.  

Is the following correct:

modifieddate - is the date of last modification by anyone who has access 

viewedbymedate - as the name suggests, this is the date that us...@domain.com last viewed the file

there isn't a "vieweddate"  field that shows the last view by anyone that has access.

Thanks!

Joseph

[Ross Scroggs]

there isn't a "vieweddate"  field that shows the last view by anyone that has access.

No

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/eb5a4e76-31c4-490d-89ce-b38574654dadn%40googlegroups.com.