Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I create a list, with all inactive Users?

kadir sünbül October 29, 2013

Maybe i didn't found a way, i would like create or see a list with all inactive Users. How can I fix this?

5 answers

1 vote
kadir sünbül October 29, 2013

OH, thanks but i mean, do this over the jira webinterface.

0 votes
Patrick van der Rijst
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 8, 2014

Or look at the groups that are listed in the Global Permissions of the permission JIRA Users. Everyone that is in that group is an active member in JIRA.

0 votes
kadir sünbül October 29, 2013

Thank s Taun and Peter. Let s do it :)

0 votes
Peter Van de Voorde
Community Champion
October 29, 2013

Hi Kadir,

You can only do this easily through a query in your jira database.

Tarun has already proved the query :

SELECTu.user_name,u.first_name,u.last_name,u.email_address,d.directory_name fromcwd_user u joincwd_directory d onu.directory_id = d.id whereu.active = 0;

Best regards,

Peter

0 votes
Tarun Sapra
Community Champion
October 29, 2013

SELECTu.user_name,u.first_name,u.last_name,u.email_address,d.directory_name fromcwd_user u joincwd_directory d onu.directory_id = d.id whereu.active = 0;

Suggest an answer

Log in or Sign up to answer