How to get actual directory path where the Documentum documents are stored in the server
How can I obtain the actual directory path where the Documentum documents are stored on the server? Additionally, how can I retrieve the Document Object ID?
I have a script provided by the previous employee who managed the Document Management System (DMS). However, when I attempted to execute the script in the DMS database, an error occurred with the message 'Invalid object name 'dm_document'
Sample script:
SELECT file_system_path FROM dm_location WHERE object_name IN (SELECT root FROM dm_filestore WHERE name IN (SELECT a_storage_type FROM dm_document WHERE r_object_id = '0000000X0000000X0'))
Answers
-
You can use the API command : getpath,c,<docid>
1 -
Thank you for the quick response @Hicham Bahi.
Where can I find the API command, is it inside the DMS application? See the screenshot below.
I apologize; I am new to DMS.
0 -
That's the one. You can also use iapi on the server. You should probably ask your employer to send you to a training if you are going to take care of Documentum in the future…
1 -
@Hicham Bahi Okay, I will try that. Thanks! Our version is old and sad to say no MA support for several years, but they plan to upgrade or replace the application soon.
0 -
@Hicham Bahi This is the result when I execute the script in API Tester.
0 -
content objects start with 09x. You're trying with a 3dxxxx (dm_server_config?) that it is a contentless object, so no path is returned
1 -
@KCastrillo you need to replace <docid> with the ID of your document. It should start with 09. Example below:
getpath,c,0900000180011fad
1
Categories
- All Categories
- 117 Developer Announcements
- 52 Articles
- 145 General Questions
- 133 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 81 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 167 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 4 XM Fax