Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT u.lower_user_name
- FROM cwd_user u
- JOIN cwd_membership m
- ON u.id = m.child_id
- AND u.directory_id = m.directory_id
- JOIN licenserolesgroup lrg
- ON Lower(m.parent_name) = Lower(lrg.group_id)
- JOIN cwd_directory d
- ON m.directory_id = d.id
- WHERE d.active = '1'
- AND u.active = '1'
- AND license_role_name = 'jira-software';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement