Does anyone have a SQL query or PDM report to search for files that have been recovered? Searching the history doesn't search the event description.
Here you go... something to start with
SELECT Documents.Filename, Projects.PathFROM Documents INNER JOIN HistoryDelete ON Documents.DocumentID = HistoryDelete.DocumentID INNER JOIN DocumentsInProjects ON Documents.DocumentID = DocumentsInProjects.DocumentID INNER JOIN Projects ON DocumentsInProjects.ProjectID = Projects.ProjectIDWHERE (HistoryDelete.Action = 2)
Francisco | CSWS-DMA
Thanks! I finally got around to trying this. Works great!
Retrieving data ...