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
GoEngineer
Thanks! I finally got around to trying this. Works great!
Jennifer
Here you go... something to start with
SELECT Documents.Filename, Projects.Path
FROM Documents INNER JOIN
HistoryDelete ON Documents.DocumentID = HistoryDelete.DocumentID INNER JOIN
DocumentsInProjects ON Documents.DocumentID = DocumentsInProjects.DocumentID INNER JOIN
Projects ON DocumentsInProjects.ProjectID = Projects.ProjectID
WHERE (HistoryDelete.Action = 2)
Francisco | CSWS-DMA
GoEngineer