Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Get groups from JIRA which are in AD & Jira internal Directory

Govindaraj Sundaram
Govindaraj Sundaram April 20, 2017

Need customized postgresql query to get the list of user with there associated group with details like whether the assocaiated group is AD/Local.

Please help to get the list.

Answer
Watch
Like Be the first to like this
437 views

1 answer

0 votes
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
April 20, 2017

Look in the cwd_ tables.  cwd_user will tell you about the users and which directory they are in, and cwd_membership will give you the membership of their groups.

I'm not 100% sure I would give you the right "join" for the question you are probably asking, but cwd_membership alone may well be able to answer it

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events