How I can know that users are only included in a group?

[Eva Fernández]

Hello,

How I can know that users are only included in a group?

Now the query, I see users who are in a group. But I need to see those who are only in a particular group. I want to see that users are "only" included in the "jira-users" group.

    select * from jira.cwd_membership where parent_name = 'jira-users';

Thank!!!

Eva - from spain

[Peter Geshev · Accepted solution]

Hi Eva,

You can try the following query 

SELECT m.* 
FROM cwd_membership m
LEFT JOIN cwd_membership m1 ON m1.CHILD_ID = m.CHILD_ID AND m1.PARENT_ID <> m.PARENT_ID
WHERE m.parent_name = 'jira-users' AND m1.id IS NULL

Regards,

Peter

[Eva Fernández]

it works!! Thank you very much!

Eva