SQL to return all users in "Jira Interal Directory"

DI2E Licensing
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2014

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!

1 answer

1 accepted

1 vote
Answer accepted
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2014
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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2014

Thanks!

Suggest an answer

Log in or Sign up to answer