inactiveUsers function returns also active users

I was trying to list issues which are assigned to inactive users. I used the inactiveUsers function like this:

assignee in inactiveUsers()

but it didn't work properly. It displayed almost all the issues.

The reason of this is the following, I think. Recently we have upgraded JIRA to use LDAP instead of JIRA internal Directory. The users names hasn't changed, because the everybody had thesame username in JIRA as in Active Directory. After the migration I can see in the CWD_USER table, there are two records for each user, one for the JIRA internal directory (DIRECTORY_ID = 1), and one for AD (DIRECTORY_ID = 10000). We wanted to avoid the usage of the old JIRA account, so we have disabled them all. There was no problem, because the AD was the primary directory, so everybody can login to Jira.

The problem with the inactiveUsers() function is, that it ignores the primary AD, and it thinks the users are disbaled, because one record of each user is disabled.

Is there any workaround for this problem?

3 answers

This widget could not be displayed.

By design, the plugin looks at the inactive flag in database.

Actually, you do not need to disabled in the internal user directory account to make sure it is not used. As long as you have a corresponding LDAP account and LDAP account is sorted above the internal user directory, JIRA will only use that account.

This widget could not be displayed.

Hi Jobin,

Yes, I know, but we move the inactive users to an other organization unit in the active directory. This OU is out of scope of Jira, so this users are not synchronized. That's why we disable the JIRA logins to avoid getting enabled them after the AD account disappear from Jira.

Laszlo

But, that is only for disabled users, right? I thought you were saying that you disabled all users in internal user directory?

Yes, we has disabled all internal users, because once they get disabled in AD and moved to the other OU, then we need to be sure that the account is also disabled in Jira.

This widget could not be displayed.

Hi Jobin,

Do you have any information, if there is any plan to fix this bug in the JQL Tricks Plugin, or we need to find out some workaround, or use some other tool to query inactive users' issues.

Best regards,

Laszlo

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

516 views 3 18
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you