My total file count is incorrect because the same file was duplicated into multiple folders. How can I quickly identify a file that is in more than one location.
Basically if 2 objects are identical that reside in 2 different locations, please bring them back in a query.
Could you refer following article and let me know whether those are helpful to you or not ?
How to find all documents with duplicates within a Clearwell case.
How to Calculate the number of duplicates for a given document