The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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 _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 !!
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.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.