Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,974
Community Members
 
Community Events
165
Community Groups

SQL query with "JIRA user login count"

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

 

 

1 answer

1 accepted

2 votes
Answer accepted

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

Like Sagar Mahajan likes this

Hi Alexey ,

That also worked for me .

Thanks !!!!

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 !!

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you