How can I view a list of checked out documents and the name of the user who has it checked out using

CasperBoyles

Hi Everybody

We are trying to execute a DQL query to produce a list of files checked out on Documentum and tell us who currently has the file checked out.

I thought this would show all the files and list by the name of the person who has the file checked out:

select * from dm_document where r_lock_owner is not nullstring;

ORDER BY r_lock_owner

It does provide a list of checked out files and has an owner_name column but I cannot see who has the document checked out so the query is useless.

Any help on this would be much appreciated.

Kind Regards

Casper

Haroon_A

Try this:

select

  d.r_object_id,

  d.object_name,

  u.user_name,

  u.user_os_name,

  u.user_os_name,

  u.description

from

  dm_document d,

  dm_user u

where

  d.r_lock_owner is not nullstring and

  d.r_lock_owner=u.user_name

order

  by d.r_lock_owner