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 _Appfire_ · 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

[vinod vaddi]

Hi Alexey ,

That also worked for me .

Thanks !!!!

[RichardA]

Hi @Alexey Matveev _Appfire_ , We need information to get number of users logged on particular time interval in jira application.

for example today 27-09-2021 from 9am to 10am.

we are using Oracle DB.

Pls suggest

Thanks !!

[Alessandro Lombardo]

Hi @RichardA you can only track last login of users ( you can see the queries here https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html ) and then you can count number of users that has logged in in a certain period. But there are not historical data about user logins