Files or Items Last Accessed Date RRS feed

  • Question

  • I have an intranet site with Sharepoint 2010; Audit log is enabled and trimming data set to 60  days. Is there a way to get the list of all files or items within the site collection with the last accessed date property?

    using SQL, Powershell or even custom audit report ...etc


    Monday, June 6, 2016 10:02 AM



    If you want to get the list of all file or items last modified time, there is a PowerShell script which is intended to get the "LastModifiedDate" property (amongst others) of all sites in your SharePoint farm. The gathered data is exported to a csv file, and optionally sent by email with the report as attachment.

    More information, please refer to the link:


    If you want to get the list of all files or items last view time, you may need to parse the IIS logs.

    Or you can create a custom column to store access date when users access the item/file.

    Best Regards,

    Linda Zhang

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, June 7, 2016 6:30 AM

All replies