postgres query for user information

VL May 13, 2021

I am running the query on this page to get user data.

https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html

What it does not give me is the list of all people who are using a license but have never logged in.   What I want is, for all license holders show me when they logged in last, and null if never logged in.

Can anyone please help with that?

1 answer

0 votes
Charlie Misonne
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 14, 2021

On this page you will find a query to get all licensed users. The query does not contain te last login information but you can adapt the query to include it. You'll need to join the cwd_user_attributes table like it's done on the page you linked.

Get list of licensed users in Jira server 

Suggest an answer

Log in or Sign up to answer