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,…

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…

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…

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…

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…

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,…

What programming language is being used for the entry criteria and actions in a specific lifecycle (T=Java, F=DocBasic): SELECT java_methods FROM dm_policy WHERE object_name = '' List all validated and installed lifecycles in the repository: SELECT object_name FROM dm_policy WHERE r_definition_state = 2  List  documents that are attached to a lifecycle, and display…

List all alias sets and their aliases: SELECT object_name, alias_name, alias_value, alias_category FROM dm_alias_set  List all permission set templates in the system: SELECT object_name FROM dm_acl WHERE acl_class = 1