{"id":1021,"date":"2025-01-29T17:04:00","date_gmt":"2025-01-29T15:04:00","guid":{"rendered":"https:\/\/jakobsens.net\/?p=1021"},"modified":"2025-07-08T12:24:16","modified_gmt":"2025-07-08T10:24:16","slug":"find-user-membership-in-groups-in-documentum","status":"publish","type":"post","link":"https:\/\/jakobsens.net\/?p=1021","title":{"rendered":"Find user membership in groups in Documentum"},"content":{"rendered":"\n

How to find group membership for a specific user using DQL.
This can help is you change the service user running Documentum Content server:<\/p>\n\n\n\n

Run below DQL in Administrator or dqMan :<\/p>\n\n\n\n

select<\/strong> r_object_id,group_name as<\/strong> object_name,owner_name,group_class,description,’0000000000000000′ as<\/strong> i_folder_id,0 as<\/strong> r_runtime_state
FROM<\/strong> dm_group
where any<\/strong> users_names = ‘dmadmin’
  OR<\/strong> owner_name = ‘dmadmin’
  order by<\/strong> group_name<\/p>\n","protected":false},"excerpt":{"rendered":"

How to find group membership for a specific user using DQL.This can help is you change the service user running Documentum Content server: Run below DQL in Administrator or dqMan : select r_object_id,group_name as object_name,owner_name,group_class,description,’0000000000000000′ as i_folder_id,0 as r_runtime_stateFROM dm_groupwhere any users_names = ‘dmadmin’  OR owner_name = ‘dmadmin’  order by group_name<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1021","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/jakobsens.net\/index.php?rest_route=\/wp\/v2\/posts\/1021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jakobsens.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jakobsens.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jakobsens.net\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/jakobsens.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1021"}],"version-history":[{"count":4,"href":"https:\/\/jakobsens.net\/index.php?rest_route=\/wp\/v2\/posts\/1021\/revisions"}],"predecessor-version":[{"id":1033,"href":"https:\/\/jakobsens.net\/index.php?rest_route=\/wp\/v2\/posts\/1021\/revisions\/1033"}],"wp:attachment":[{"href":"https:\/\/jakobsens.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jakobsens.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jakobsens.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}