📖 < 1 min read

For Admins interested in cleaning up externally shared files that have gone ‘cold’. GAT helps you find which files are shared externally and not visited in the last 90 days

The simple solution is implemented as follows.

Open Drive audit

GAT+: Which files are shared externally and not visited in the last 90 days? 1

Apply custom filter and search for Shared out files which were updated more than 3 months ago (In this case we just choose a date which is 3 months in the past).

GAT+: Which files are shared externally and not visited in the last 90 days? 2

Use the example above (just adjust the Updated date), then hit ‘Apply’.

Once the search is complete you will see the result with all the Shared out files which have not been updated in the past 3 months.
You can quickly see how many files overall there are from the result received. Simply select ‘Show stats for the current filter

GAT+: Which files are shared externally and not visited in the last 90 days? 3

Note: If you want to ignore – Trashed files (see from the results above), simply add extra search field and ignore them. You can exclude the “deleted” too.

GAT+: Which files are shared externally and not visited in the last 90 days? 4

This shows all files not read in the last 90 days that are shared out. This may be quite a large number of files.
Using ‘Schedule/Save’ you can do the following.

Run a daily or monthly report to get this list.

GAT+: Which files are shared externally and not visited in the last 90 days? 5

Automatically revoke the external sharing. (using Scheduled reports under) 

Warn the local owners with a tailored message asking them to remove the share.

Or you can do any combination of the above.

You can also run a one off job to do the same.

If you schedule this task to run daily, the 90 day lookback window will automatically be moved forward on a daily basis.

GAT+: Which files are shared externally and not visited in the last 90 days? 6
Thanks for sharing and spreading the word!