Duplicate and Master report from CP

Question

Has anyone generated an Audit Report (via Report Builder) that will list the Duplicate Files and their Master Location?

We will be deleting some internal duplicates in a File Share but would like to have a report, for future use, to show where the Master file name and path location.

OR

Just an export where I can include properties that will export to a spreadsheet.

Either one will do but I don't think any of the Advanced Properties would show the Master except the MD5 that matches the Master

Thanks!

Colin Rutledge · Accepted Answer

Hi Erik, 
 I'm not aware of anyone creating an audit report for this however I can share with you a SQL script to produce a duplicate report which will work with fileshares. It gets the list of duplicates the master document for each. 
 Please unzip the attached file called duplicateDocumentReport.zip 
 Load both stored procedures in SQL Server where your CP databases reside. 
 Then, to generate a report of duplicates change name for Repository to desired repository name e.g. 'folder3' and run: 
 USE [ControlPointMetaStore] GO DECLARE @return_value int EXEC @return_value = [dbo].[GetListOfDuplicateDocuments] @RepositoryName = N'folder3' 
 The results will be in results pane. You can highlight the rows and copy them as required. Please note that the order of the list is that the master document is shown first with the master flag set to 1 and all the following documents are the duplicates until next document with master flag set, and the order repeats. 
 
 Regards, 
 Colin

Menu

ControlPoint Discussions

Verified Answers

Duplicate and Master report from CP

Tags:

Top Replies

Resources