Local Users Removal

[Jony Gurfinkel]

We are using LDAP authentication in order to log in to Jira.

However, as its a very old system , I identify 3K local users in the system that are unused.

Is any easy way to delete them? or at least how I can extract such list

[Tom Lister]

Hi @Jony Gurfinkel 

You can get a list of users using SQL

select * from cwd_users where directory_id  = 1

1 is the id of the basic internal directory installed with Jira.

In the user maintenance pages you can delete internal user entries. But this will not delete users if they have references from existing Jira issues. 

Deep cleaning of users will require a more detailed knowledge of your specific system.

If you want to move old users on to the new LDAP user ids, there are some possibilities documented here https://community.atlassian.com/t5/Atlassian-Migration-Program/Jira-LDAP-Migration-using-SQL/ba-p/942752#M684