Forum Discussion
Jonathan Herschel
Apr 12, 2022Copper Contributor
Notifications for files deleted under retention policies
Hello, I have a client who has implemented Retention policies to delete files on SharePoint after 2 years. It is working as intended, but a pain point is users would like to be notified when a file...
MillerAT
Jul 22, 2022Copper Contributor
HerschelJ, Can you tell me how you created the automated report of files about to reach the retention policy?
HerschelJ
Jul 22, 2022Brass Contributor
I use ShareGate reporting tool to list all files a site that include the last modified and retention label column and export to excel to filter and sort all files modified over 5 years ago where retention label = our six year retention label and shows all files that will get deleted in the next year. Could also do the same in Powershell. Foreach library, show filename, last mod, modified by, label column and dump to csv.
- HerschelJJul 22, 2022Brass ContributorSite Owners could also create a weekly alert to show them all deleted files in case they want to pick the trash 🙂
- JHersch77Jul 22, 2022Copper Contributorduh, even easier, if there are less than 5k files in your library create a view with those columns and export to excel no code, no 3rd party solutions... its Friday, I'm a little slow...