how to build a search for duplicate files

Content Management

This is where you can find and contribute to discussions, ideas, and other information about ProjectWise Content Management products.

Content Management - Forum

how to build a search for duplicate files

rated by 0 members
This post has 2 Replies |
0 Followers

Posted by Jeff Burrill

on Wed, Jan 27 2010 10:43 PM

rated by 0 members
Post Points: 5
Re: how to build a search for duplicate files

If you do run Dean's query and you do any kind of ProjectWise versioning that keeps the same file name through the versions, you should add something like o_original=0 to only check current versions.

Posted by DeanLyon

on Wed, Jan 27 2010 9:24 PM

rated by 0 members
Post Points: 5
Re: how to build a search for duplicate files

not genericly, that I am aware of. You could use SQL and query the dms_doc table. something like this:

Select Count(o_filename)as docCount,o_filename from dms_doc group by o_filename Having Count(o_filename) > 1

This should list which filenames are listed more than once. You will then need to take the filename and to projectwise to search on the filename to find the documents.

Posted by mjmconsulting

on Wed, Jan 27 2010 9:03 PM

rated by 0 members
Post Points: 45
how to build a search for duplicate files

is it possible to build a search in PW for duplicate files using the search building tool?

TIA,
Mike