SQL to return all users in "Jira Interal Directory"

Question

We're running postgres.  I'd like a query that will return all the info I can get re. users in the JIRA internal Directory.  (As opposed to the AD directory.)

thx!

Jobin Kuruvilla [Adaptavist] · Accepted Answer

select * from cwd_user where directory_id = 1

1 is the id for JIRA internal directory. Change as appropriate for other directories. You can find directory info under cwd_directory table.