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

[Nageswarara Rao]

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?

[Renjith Pillai]

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'

[Renjith Pillai]

Similar, it has the table details

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

[Nageswarara Rao]

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