As per title I want to return the full path of all documents on the server. I found that the "dms_doc" table has everything I need for a specific task except the full path for each document. Any ideas which table I can look at that will contain the fully qualified path of each folder?
Hopefully once I know which table contains the full path it will also have either project GUID / project number; then I can relate that back to those columns in dms_doc to expand it to include a full path to each file.
The full path values are derived. There isn't a table in ProjectWise containing those values.
OK thanks Brian, I assume when you say they are derived that you mean I need to recurse through the folder tree to populate all the paths myself, as Kevin mentions below?