(private) sorry...!! contact@ecmnotes.com
slide

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

slide

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…

slide

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…

slide

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

slide

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

slide

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…

slide

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…

slide

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…