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...
HerschelJ
Brass Contributor
Thanks Christian, agreed, it defeats the purpose. Can't have both.
In case anybody is following this thread, I did come up with Automated reports to send Site Owners a list of all files where the retention policy will be reached in the next 6 months so they can modify them before they get deleted. could probably do the same in PowerShell, I just wanted to make sure I wasn't missing something like a checkbox somewhere...
In case anybody is following this thread, I did come up with Automated reports to send Site Owners a list of all files where the retention policy will be reached in the next 6 months so they can modify them before they get deleted. could probably do the same in PowerShell, I just wanted to make sure I wasn't missing something like a checkbox somewhere...
MillerAT
Jul 22, 2022Copper Contributor
HerschelJ, Can you tell me how you created the automated report of files about to reach the retention policy?
- HerschelJJul 22, 2022Brass ContributorI 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...