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

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

Aliases
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

DocApps
Display the object IDs of all objects contained in a specific DocApp: SELECT application_object_id FROM dm_application WHERE object_name = ‘' What is the version label of a specific DocApp: SELECT app_version FROM dm_application WHERE object_name = ''

Searching
List all searchable attributes: SELECT attr_name, type_name FROM dmi_dd_attr_info WHERE is_searchable = 1 ORDER BY type_name List all searchable dm_document attributes: SELECT attr_name FROM dmi_dd_attr_info WHERE is_searchable = 1 and type_name = 'dm_document' Display information about the full-text index: SELECT * FROM dm_fulltext_index List all the documents which contain the set of words: SELECT *…