Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How to find users' login history?

Madhura Kulkarn
Madhura Kulkarni June 17, 2012

Is it possible to find how many/which users logged into Jira during a particular time range? (by querying the database)

Answer
Watch
Like # people like this
1665 views

2 answers

0 votes
Renjith Pillai
Renjith Pillai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
January 23, 2013
May be you can parse the access logs too.
Reply
0 votes
cgauterio
cgauterio
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 23, 2013

HI MAK,

Yes, it is possible to do this. We have a page with some Example SQL queries for JIRA and there is one query that might help you achieve that. Please see:

List username, full name, email address, login count, and last time logged in

Hope it helps :)

Cheers,

Clarissa.

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events