Live Report to list documents "About to be" deleted

General_Dynamics_C4_Systems

We have set our Autopurge for 90 days.I am looking to create a report that I will be able to run to list all documents which "will be" deleted in 15 days or 75 days after it was deleted.We would also like to know which user deleted the document so we can email them a finial message that the file is about to be purged.Does anyone have any ideas . . . ?

Krishnankutty_Nair

I was playing with the deleted docs and there is already a LiveREport called DeletedDocuments .I made a copy of it and tweaked the SQL,Maybe you can improve on it.All it does is subtract SysDate(time now) from the deleteddocs date so you will get the age.Run your math as an input parameter and there is your report***********************************select DTree.*, KUAF.Name "UserName", KUAF.PersonalEmail "Email",DeletedDocs.Name "Name",(SysDate-DeletedDocs.DeleteDate) as "Age", DeletedDocs.DeleteDate, DeletedDocs.OrigPath "OrigPath", DVersData.MimeType from DTree, DeletedDocs, KUAF, DVersData where DTree.DataID = DeletedDocs.NodeID and DeletedDocs.DeleteUserID = KUAF.ID and DTree.DataID = DVersData.DocID and DTree.VersionNum = DVersData.Version and DVersData.VerType is null order by DeletedDocs.DeleteDate, DeletedDocs.Name******************************************Just add a fourth display column called 'Age'and a fifth called email and you Make a copy of the dleteddocuments LR and you will get the idea