AnsweredAssumed Answered

Identifying duplicated files that are deleted

Question asked by Susan Renick on Nov 30, 2017
Latest reply on Dec 29, 2017 by Jeff Sweeney

I have run a check for duplications using query below and have over 9,000 line items to review.  I want to know which of the files are deleted so that I can have get approval to destroy as 0 files have been destroyed since implementation of PDM over 4 years ago (I just started so trying to clean up vault) and I don't want to go off and destroy thousands of files without checking first (cma)

 

is there a way to query on "is deleted" or "deleted by"? 

 

 

D.documentid, D.filename AS 'File Name', P.Path AS 'Project Path'


Documents D

 

INNER JOIN DocumentsInProjects DIP

 

ON D.DocumentID = DIP.DocumentID

 

FULL OUTER JOIN Projects P

 

ON DIP.ProjectID = P.ProjectID


D.Filename IN (SELECT Filename FROM Documents where Deleted = 0 GROUP BY Filename HAVING (COUNT(Filename) > 1))


BY D.Filename

 

Outcomes