Duplicate Files in Sharepoint
We've inherited a lot of data duplication from migrating data as is from Shared Drives directly to Sharepoint, no data cleansing was done so there are in some cases vase swathes of duplicated data.
I'm running a powershell Script that is retrieving file lists from all Sites, retrieving modified/created date, owner, file size and version info.
Each site has its own File and there's also a separate file for files over 100MB
the 100MB file has already highlighted duplicated work under 100MB in the same area which is a good start, I don't know however how I'm going to present this to Data Owners.
Has anyone done something like this before? How did you present the data to Site Owners. I'm very cautious of sending them a report with thousands of lines in due to information overload.