Solidworks PDM SQL tables get which files are not in ‘Vaulted’ state/status

Hello all,

I currently have a query created from views I made that is grabbing all the files from our PDM. I have a program I created that copies/caches these files to a local server and it creates a table of whats been cached. The 2 tables are compared to determine which files need to be cached/updated.

Now it seems that files that are seem to be messing up this process because they cannot be cached.

Here is my current query and I just need to add the state/status part to this query. I saw in the ‘Status’ table ID 27 the name is Vaulted. I’m not sure if that’s what I’m looking for I don’t see any name with private state anywhere.

SELECT d.Filename, r.RevNr, r.Date AS ModifiedDate, r.FileDate AS CreatedDate, p.Name, p.Path, r.FileSize, r.Root, d.DocumentID, p.ProjectID

FROM dbo.Documents AS d INNER JOIN

dbo.view_Revisions_MostRecentRevNr_withAddInfo AS r ON d.DocumentID = r.DocumentID INNER JOIN

dbo.DocumentsInProjects AS dp ON d.DocumentID = dp.DocumentID INNER JOIN

dbo.Projects AS p ON dp.ProjectID = p.ProjectID

WHERE (d.Filename LIKE '%pdf') AND (d.Deleted = 'False')

ORDER BY d.Filename, 'ModifiedDate'