Forum Discussion

jonboylib's avatar
jonboylib
Iron Contributor
May 13, 2022

Find Inactive Files

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.

2013
files
SharePoint Online

2 Replies

  • sherianb's avatar
    sherianb
    Brass Contributor
    May 23, 2022

    jonboylib hello, this is possible, though i don't know if Microsoft's native tools can. third-party migration solutions with discovery tools (like https://www.avepoint.com/products/hybrid/office-365-migration) definitely can though.

  • mr_w1nst0n's avatar
    mr_w1nst0n
    Iron Contributor
    May 13, 2022

    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: https://social.technet.microsoft.com/wiki/contents/articles/26066.sharepoint-site-collection-report-last-access-date-and-time.aspx

Resources