How to get actual directory path where the Documentum documents are stored in the server

KCastrillo

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'))

Hicham Bahi

You can use the API command : getpath,c,<docid>

KCastrillo

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.

Hicham Bahi

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…

KCastrillo

@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.

KCastrillo

@Hicham Bahi This is the result when I execute the script in API Tester.

AlvaroDeAndresGomez

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

AJCan

@KCastrillo you need to replace <docid> with the ID of your document. It should start with 09. Example below:

getpath,c,0900000180011fad