nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Evgenii

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

Sanjen Bariki_rtm841

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

All comments

Evgenii

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_rtm841

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_rtm841

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..

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server