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…
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
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,…
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…
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…
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…
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…
Workflows
List all workflows supervised by the current user: SELECT process_id, object_name FROM dm_workflow WHERE supervisor_name = USER List all workflows supervised by any users within a specific list of users: SELECT r_object_id, supervisor_name FROM dm_workflow WHERE supervisor_name IN ('', '', '') Return all tasks that were started a month or more late: SELECT task_number,…