DQL query to find active users count

Question

Can someone suggest me a DQL query to find the count of active users in a repository in documentum.

Below is the query I am using but it is not giving correct results, can someone suggest?

select count(user_name) from dm_user u , dm_group g  where any g.i_all_users_names = u.user_name and  u.user_state=0

Miki · Answer 1 · 2014-09-09T11:02:45.320

6

SELECT count(user_name) FROM dm_user u, dm_group g  
WHERE ANY g.i_all_users_names = u.user_name 
AND u.user_state = 1

Property user_state values are:

edited Sep 09 '14 at 11:02

answered Sep 09 '14 at 10:56

Miki

score 1 · Answer 2 · edited Oct 19 '18 at 20:53

1

SELECT count(user_name) FROM dm_user WHERE user_state = 0 and r_is_group = false

edited Oct 19 '18 at 20:53

Adrian W

answered Oct 19 '18 at 19:42

user10530795

Welcome to Stack Overflow! Thank you for this code snippet, which might provide some limited, immediate help. A [proper explanation would greatly improve its long-term value](//meta.stackexchange.com/q/114762/206345) by showing _why_ this is a good solution to the problem, and would make it more useful to future readers with other, similar questions. Please [edit] your answer to add some explanation, including the assumptions you've made. – Blue Oct 19 '18 at 23:26

2 Answers2