Forum Discussion

Iron Contributor

Jul 24, 2023

SharePoint: Report to fetch content older than X amount of time

Hello all, My M365 tenant has content size of our 1.7 PB with close to 90,000 site collections. My requirement is to fetch the report of content (should crawl through all document libraries in al...

Copper Contributor

Dec 21, 2023

ellan1537

Were you able to run a successful report? I am looking for a similar report to demonstrate the impact of setting up a retention policy that will delete files older than 5 years old and it is challenging to get data for the whole tenant. Reading through the suggestions for the Compliance Center (now Purview) the audit only allows 180 days for the report range so that's already a big limitation on time. And I don't see anything specific to content for a last modified date. Would love to hear if you were able to get the data successfully.

ellan1537

Iron Contributor

Dec 22, 2023

No direct way of fetching the report. I'm still investigating for solution

Chopper520
Copper Contributor
Jan 29, 2024
We have a 10yr retention policy and would like to warn users when the retention is met with an alert and/or pull a list of what's about to be deleted soon and warn them.

Some of the files have started deleting by system account as they retentions been met.