Venio Console: Set Duplicate files as originals.

Problem

We want to set some duplicate documents and original. Is there a way to make the identified files as original i.e. no longer dupes?

Reference ticket #13310

Resolution

First create a backup of the table tbl_ex_fileinfo table using the following query. Please run it in your project database.

select * into tbl_ex_fileinfo_bak from tbl_ex_FileInfo

The following query will identify files as original files: Please run it in your project database.

update tbl_ex_FileInfo
set IsDuplicate=0,
IsDuplicateCustodianLevel=0,
OriginalGroupId=-1
where fileid=<fileids of the files you want to recognize as original>

After this recompute the media summary by executing the following stored procedure: