How to find issues assigned to disabled user

[Cedric_DEVAUX]

Hello,

A colleague send me a remark around the search issue.

I have a disabled user (he left the company) and I want to list all issues assigned to this user.

If my colleague uses the basic search (screen shot), he doesn't find user

However only if he uses the advanced search and search issues with user account, he finds issues.

I suppose that JIRA is not able to translate user because it's inactive and if we use advanced search,  JIRA search the raw value (firstname.lastname) from the database and give the result.

For your information: we are connected on Active Directory for user management.

Someone could confirm me my theory?

Thank you

[Bastiaan Jansen · Accepted solution]

Hi Cedric, I can confirm the theory you shared is correct.
I found a knowledge arcticle about the same topic: https://confluence.atlassian.com/jirakb/search-for-inactive-users-346947771.html

Within this article there is a link to a feature request that has been closed with the JIRA 7.3 fix version: https://jira.atlassian.com/browse/JRASERVER-32874

Cheers,
Bas

[Andrew Stanton]

I dont know how you can say this is fixed and working when inactive users do not appear in filter selection lists or JQL autocomplete. 

[Raul MrAddon · Accepted solution]

Here an example of Jira JQL function HasInactiveAssignee compatible with Jira 8, the function is in the comments of the post 

https://mraddon.blog/2015/08/31/new-jql-function-custom-to-retrive-issues-with-inactive-user-in-assignee-hasinactiveassignee/

[Cedric_DEVAUX]

Hi Raul,

Thank you for your answer  ;)

[Chris Bell]

Using this JQL statement will display all issues assigned to an inactive user:

assignee in (inactiveUsers())

[Devendran Krishnan]

this solved my problem. thanks

[Damian]

Keep in mind: This is a Scriptrunner-Script. It wont work if you disable the

Scriptrunner App.

[Gary Mcdermott]

@Chris Bell  I was hoping you could help with something similar. 

An inactive user has left the business, i have followed advanced search and run  the below however it only seems to show me his 'done' tickets, its not showing me any tickets he had in the existing sprint that were under 'to do' I am trying to locate these missing tickets so i can re-assign, thanks 

(inactiveUsers())

[Igor Silva]

This should be the accepted answer.