Is there a way to identify where a file is and what it is named in the archives via sql tables? I am trying to create a SQL query that list documents with their vault path, archive name, and archive location. This is what I have so far.
SELECT Documents.Filename, Projects.Path FROM Documents JOIN DocumentsInProjects ON Documents.DocumentID = DocumentsInProjects.DocumentID JOIN Projects ON Projects.ProjectID = DocumentsInProjects.ProjectID WHERE Documents.Deleted = 0
ORDER BY Documents.Filename
SolidworksSolidworks Pdm enterprise Pdm