How do I find the storage_id of a data store in Documentum? I see it used in dmr_content table, but I can't find what that references. Thanks.
select * from dm_store where r_component = 'storage_id'
Try this query as well
select name, r_object_id from dm_filestore where r_object_id in (select distinct storage_id from dmr_content);