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'
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))