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

In which table user's last login time details will save?

Nageswarara Rao
Nageswarara Rao January 4, 2013

Hi,

I m getting the user's last login time by using LoginService interface programatically , but i want to get the last login time details using SQL query.

If Is there any posibility , please tell me how?

Answer
Watch
Like Be the first to like this
571 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 4, 2013

Did you read the sql properly, it's not a column rather a value mapped in cwd_user_attributes table. Here is thq SQL

select attribute_value from cwd_user,cwd_user_attributes where cwd_user.id = cwd_user_attributes.user_id and attribute_name = 'login.lastLoginMillis'

Reply
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 4, 2013

Similar, it has the table details

https://answers.atlassian.com/questions/87366/how-do-i-remove-all-jira-accounts-that-never-logged-in

View More Comments
Nageswarara Rao
Nageswarara Rao January 4, 2013

There is no such type of Column "Last login date" in my cwd_user table

Like
Reply

Suggest an answer

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

Atlassian Community Events

    See all events