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
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
Hi Alexey,
your SQL-query works well; I tested it yesterday.
Good job !
Well done !
Bye and best regards
Jörg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Alexey Matveev , 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 !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.