SQL to return all users in "Jira Interal Directory"

[DI2E Licensing]

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 solution]

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.

[DI2E Licensing]

Thanks!