Find Inactive Files

%3CLINGO-SUB%20id%3D%22lingo-sub-3371640%22%20slang%3D%22en-US%22%3EFind%20Inactive%20Files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3371640%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20currently%20migrating%20from%20SharePoint%20(2013)%20to%20SharePoint%20online.%20We%20want%20to%20migrate%20only%20documents%20from%20SP%202013%20that%20have%20been%20accessed%20or%20opened%20in%20the%20last%20x%20days%20%2F%20years.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20see%20the%20modified%20and%20modified%20by%20columns%2C%20but%20this%20isn't%20very%20useful%20in%20our%20scenario%2C%20as%20a%20document%20could%20be%20opened%20every%20day%20but%20never%20modified.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3371640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3372495%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20Inactive%20Files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3372495%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1343275%22%20target%3D%22_blank%22%3E%40jonboylib%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20this%20can%20be%20possible.%3C%2FP%3E%3CP%3EMostly%20all%20migration%20tool%20are%20using%20the%20last%20modified%20date%20as%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20possible%20approach%20%3CEM%3E(I%20never%20tried%20it)%3C%2FEM%3E%20could%20be%20to%20query%20directly%20the%20back%20end%20SQL%20content%20database%20and%20see%20if%20any%20column%20%22lastAccessDate%22%20is%20present.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20possible%20for%20site%20but%20not%20sure%20it%20exist%20anything%20similar%20for%20Docs%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F26066.sharepoint-site-collection-report-last-access-date-and-time.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESharePoint%20site%20collection%3A%20Report%20Last%20access%20date%20and%20time%20-%20TechNet%20Articles%20-%20United%20States%20(English)%20-%20TechNet%20Wiki%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

We are currently migrating from SharePoint (2013) to SharePoint online. We want to migrate only documents from SP 2013 that have been accessed or opened in the last x days / years.

 

Is this possible?

 

I can see the modified and modified by columns, but this isn't very useful in our scenario, as a document could be opened every day but never modified.

1 Reply

@jonboylib 

 

I'm not sure this can be possible.

Mostly all migration tool are using the last modified date as reference.

 

A possible approach (I never tried it) could be to query directly the back end SQL content database and see if any column "lastAccessDate" is present.

 

This is possible for site but not sure it exist anything similar for Docs: SharePoint site collection: Report Last access date and time - TechNet Articles - United States (Eng...