Where are all JIRA accounts stored in database?

Błażej O_

I'm trying to pull all Jira accounts from database. Where can I find exactly the same account list as through the User Management in Jira?

Distinct from cwd_user shows twice as much user accounts as User Management.

Distinct from external_entities shows ~30% more user accounts than User Management.

Nic Brough -Adaptavist-

It's cwd_user.

I suspect your "distinct" might be confusing things, although you have not told us what you're doing with it - users can be duplicated across directories with the same name, which could well explain what you're seeing.

As an example, I set up a client's JIRA recently.  I'm nic in the internal directory.  I'm nic in their main site's internal directory, I'm nic-s in another site's directory and I'm nic in the Adaptavist directory.  Doing a "distinct" based on the login id will give you 2 answers, which is wrong.