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

Question

Hello,

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 Answer

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