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?
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'
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG