postgres query for user information

[VL]

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?

[Charlie Misonne]

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