Active user list from linux project wise

[Suma Pralhad Kustagi]

Hi, 

 Can you please help me to get user list with their name, userid and email address

from jira server( linux login with postreg db).

Regards,
Suma

[Evgenii · Accepted solution]

Hi, @Suma Pralhad Kustagi 

Hope, this will help you. It's very similar to your question

https://community.atlassian.com/t5/Jira-Software-questions/Re-How-to-pull-the-overall-number-of-logins-this-month-f/qaq-p/2295194/comment-id/253965#M253965

Or here link to Atlassian KB:

https://confluence.atlassian.com/jirakb/identify-users-in-jira-who-haven-t-logged-in-for-the-past-90-days-695241569.html

[Suma Pralhad Kustagi]

@Evgenii thank for the response. This would yeild in providing last login but i would need project wise active user list

[Sanjen Bariki · Accepted solution]

Hi @Suma Pralhad Kustagi ,

Welcome to Atlassian community!

Please use the below command to connect with PostgreSQL dB in Linux.

• psql -U <username> -d <database_name>

Once you are connected to the database, execute the following SQL query to retrieve the user list

• SELECT lower_user_name AS username, display_name, email_address FROM cwd_user;

Please accept the Answer If it helps you.

Thanks

Regards,

Sanjen 

[Sanjen Bariki]

Hi @Suma Pralhad Kustagi 

Greetings.

If you need the the list project wise active list.

Please user the below query.

SELECT lower_user_name AS username, display_name, email_address, p.pname AS project_name
FROM cwd_user u
JOIN projectroleactor pra ON u.directory_id = pra.directory_id AND u.lower_user_name = pra.roletypeparameter
JOIN project p ON p.id = pra.project_id;

Please accept the answer If it helps you!

Regards,

Sanjen Bariki

[Suma Pralhad Kustagi]

@Sanjen Bariki I get pra.directory_id does not exists..