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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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