See who last changed a file

Build a report that shows, for each file, who changed it last and when.

Before you begin

• Your Rencore role needs the permissions to create reports. See Rencore roles.
• SharePoint and OneDrive are connected. File data needs the Files & Folders add-on.

Steps

To see who last changed your files, you will need to:

1. Go to Reports > Add Report.
2. Click Create Custom Report. See Create a Custom Report.
3. On the “Logic” screen, select the SharePoint object “File”. For OneDrive, select the OneDrive object “File”.
4. Add filters to narrow the files, for example on “Site Url”, “List Name” or “File Extension”.
5. To see the files one person changed, add a filter on “Modifier”.
6. Click Preview, then click Next.
7. On the “Visualization” screen, choose a table and show “File Name”, “Modifier”, “Modified By Name” and “Modified”.
8. On the “Details” screen, give the report a title, then click Save.

What you see

Each row shows a file with the person who changed it last and the date of that change. You can share the report or export the data to PDF or Excel.

Limits

• The report shows the last change only, as of the last file scan. It is not an activity history.
• Opened, viewed and downloaded events are not in the inventory. Use Microsoft Purview for those.
• The person is shown by their user principal name in “Modifier”.