1 Reply Latest reply on Dec 29, 2017 3:51 PM by Jeff Sweeney

    Identifying duplicated files that are deleted

    Susan Renick

      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