Finding file path from object id for deleted object

I have a situation on a client docbase where a number of sysobjects have been deleted. Unfortunately, the dmclean job has run, so the dmr_content objects are also deleted, but the dmfilescan job doesn't run on a schedule, so the files (presumably) still exist on the filestore. My question is: given only the r_object_id of the deleted sysobject, how can I identify the file path? I've tried the GET_FILE_URL administrative method, and the "getpath" API command, but they also don't work, throwing an exception when they try to fetch the (nonexistent) sysobject.

Any ideas? Thanks in advance ...

Find more posts tagged with

Comments

aflowers001

Unfortunately once the sysobject AND dmr_content are gone so is any way to look something up on the filesystem.

If you have any auditing in place you could check the audit trail to see if there is anything in there around the deletes, and possibly take a look at the dmclean job logs?

Supratim007

if dmr_content exists then u could try this

select * from dmr_content where any parent_id in (select r_object_id from dm_document where folder('/<Foldr Path>',descend) and object_name like '<object_name>')

and then with the r_object_id run the following command

API> apply,c,<r_object_id of dmr_content table >,GET_PATH

API> next,c,q0

API> get,c,q0,result

I do not think if relevant entries are deleted from dmr_content table then there is any option to retrieve the file store path.