Mumbai, India
ecmnotes.com parag@ecmnotes.com
Documentum

Virtual Documents

List all direct children of a specific virtual document (identified by object ID): SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') List all direct children of a specific virtual document (identified by object ID and a version label): SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') VERSION 1.1 List all children of a specific virtual document, including components of nested virtual documents: SELECT object_name, subject, authors FROM dm_sysobject  IN DOCUMENT ID('') DESCEND Return the identified virtual document and…

Documentum

Groups and Roles

List all roles in the system: SELECT group_name FROM dm_group WHERE group_class = 'role'  List all users who are members of this group, including those who are members of groups contained in this group: SELECT i_all_users_names FROM dm_group WHERE group_name = '' List all groups a particular user can modify: SELECT group_NAME from dm_group WHERE group_admin = '' or owner_name = '' Create a new group with an associated e-mail address and a specific list of members: CREATE GROUP ABC WITH…

Documentum

Users

Show when a user’s properties were last changed: SELECT r_modify_date FROM dm_user WHERE user_name = '' List all deactivated user accounts: SELECT user_name FROM dm_user WHERE user_state = 1 List the LDAP servers being used to authenticate users: SELECT user_login_domain FROM dm_user WHERE user_source = 'LDAP'  List documents currently checked out by a particular user: SELECT object_name FROM dm_document WHERE r_lock_owner = '' Find the list of users who have not logged into Documentum for X no of days:…

Documentum

Object security (ACL)

Display the folder security setting for this repository (0=disabled, 1=enabled): SELECT folder_security FROM dm_docbase_config  Show the default ACL mode for the Content Server: SELECT default_acl FROM dm_server_config List the objects associated with this permission set: SELECT object_name FROM dm_sysobject WHERE acl_name = '' and acl_domain = '' List the permission sets that specifically reference this user: SELECT object_name, owner_name FROM dm_acl WHERE any r_accessor_name = '' To set ACL of home cabinet of all newly created users: update…

Documentum

Full-Text

Return all indexed documents that contain the word “”: SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS '' Return all indexed documents that contain “” or “” or both: SELECT object_name, owner_name, r_creation_date  FROM type SEARCH DOCUMENT CONTAINS ''  Return all indexed documents that contain the phrase “”: SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS '""' Return all indexed documents that contain the word “” or the phrase “” or both: SELECT object_name, owner_name,…

Documentum

Renditions

Display all objects that have renditions: SELECT r_object_id, object_name, a_content_type, r_object_type,r_lock_owner, r_link_cnt FROM dm_document WHERE r_object_id IN (SELECT parent_id FROM dmr_content WHERE rendition > 0) Display all of objects that have PDF renditions: SELECT r_object_id, object_name, a_content_type, r_object_type,r_lock_owner, r_link_cnt FROM dm_document WHERE r_object_id IN (SELECT parent_id FROM dmr_content WHERE full_format='pdf’ and rendition > 0) and owner_name = USER

Documentum

Objects and Content

Retrieve information about a specific content file: SELECT r_object_id, parent_id, page, rendition,content_size, set_time, set_client, set_file FROM dmr_content WHERE ANY parent_id = ''  Which objects depend on a specific content file: SELECT r_object_id, object_name, a_content_type,r_object_type, r_lock_owner, r_link_cnt FROM dm_sysobject WHERE i_contents_id = '' How many content files are associated with a specific object: SELECT r_page_cnt FROM dm_document WHERE r_object_id = ‘’  What are the object IDs of the content objects associated with a specific object: SELECT r_object_id FROM dmr_content WHERE ANY parent_id =…

Documentum

Documents

List all documents owned by a specific user: SELECT object_name FROM dm_document WHERE owner_name = '' List all documents that contain specific keywords: SELECT object_name FROM dm_document WHERE ANY keywords = '' and ANY keywords = ''  List all documents that have been checked out since yesterday, and who checked them out: SELECT object_name, r_lock_owner FROM dm_document WHERE r_lock_date >= DATE(YESTERDAY) List all documents created by a specific user within a specific time frame: SELECT r_object_id, object_name, r_object_type,a_content_type, r_link_cnt FROM dm_document WHERE…

« Previous Page