Get ID For Deleted Users

[Dolev Sall]

Hi,

So i am trying to prepare yearly report generated with JQL. Part of my query is by assignee and it seem that our IT deleted inactive users.

The thing is, if i have the ID of the specific user, i am able to query with it. But i can't seem to find the relevant IDs anymore..

Is there a way to get it?

We use JIRA which is sync with G-suite.

Thanks

[Dolev Sall]

Just updating that in the end we had to use DB query using Atlassian instructions. So it is not possible using JQL. Once you have the IDs, you can use in JQL.

[Rilwan Ahmed]

Hi @Dolev Sall ,

You can get the list by using JQL 
assignee not in membersOf("jira-users-group"). 
Replace jira-users-group by your jira access group. This will be the group which grnats access to your jira. You can find them under Admin --> Application --> Application access. 

It shows all issues that have been assigned in the past to users that are now no longer active. You can refine your search by also filtering only on issues that are still open.

[Pramodh M]

Hi @Dolev Sall 

Once you delete the user the data is not gone yet!!

Inviting them back with no site access would be sufficient to search the data that is related to them.

It's best if you ask your IT team to invite them back and maybe keep their account inactive in Jira?

Check with your IT team.. for the deleted users and inviting them back would be sufficient. No need to provide any product access

Thanks,
Pramodh