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

[Govindaraj Sundaram]

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.

[Nic Brough -Adaptavist-]

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