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