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
Walter,
Sorry, I tested that with a limited fileset, you need to add a right to the first fnHexNumber:
SELECT 'C:\Program Files\SolidWorks Enterprise PDM\Data\EPDM-Vault\'+right(dbo.fnHexNumber(Documents.DocumentID,1,1),1)+'\'+dbo.fnHexNumber(Documents.DocumentID,8,1)