SQL query with "JIRA user login count"

[Jörg Geraldy]

Hi all,

we want to create a JIRA user management report with the following fields:

username, Full name, login counts, last login

Is it possible to get this report with a SQl query ?

Let me know.

Thanks a lot in advance

bye and best regards

Jörg

[Alexey Matveev · Accepted solution]

Hello,

It would be something like this

SELECT user_id, display_name, updated_date last_login, attribute_value login_count FROM cwd_user a, cwd_user_attributes b where attribute_name = 'login.count'
and a.id = b.user_id

[Jörg Geraldy]

Hi Alexey,

your SQL-query works well; I tested it yesterday.

Good job !

Well done !

Bye and best regards

Jörg