Commodore Commodore
Commodore
209 views

Duplicate and Master report from CP

Jump to solution

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!

0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

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

View solution in original post

1 Reply
Micro Focus Expert
Micro Focus Expert

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

View solution in original post

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.