Jira User Last Login Date is different from the Crowd Database user last login date

Can Yılmaz August 22, 2019

Hey Everyone,

 

I have a Jira and Crowd. When i look at the last login information from Jira User page; the last login date is wrong (It says Last: 10/08/18 5:52 PM when it should be 22/08/19 3:03 PM). But ,  the last login information is wrong only on Crowd Directory Users, Jira Internal Users' last login date is correct. So, i checked the Crowd Database; last login informations on Crowd Database is correct, but same last login information for same user is wrong on Jira Database.

What could be the reason for this ?

Is this a integration problem ? (Jira and Crowd seems to be working correctly)

Jira Version : 7.0.10

Crowd Version : 2.11.0

DB : Oracle

These're the sql's : 

Jira DB sql : 

SELECT d.directory_name,
u.user_name,
TO_DATE('19700101','yyyymmdd') + ((attribute_value/1000)/24/60/60) as last_login_date
FROM JIRA.cwd_user u
JOIN (
SELECT DISTINCT child_name
FROM JIRA.cwd_membership m
JOIN JIRA.licenserolesgroup gp ON m.parent_name = gp.GROUP_ID
) m ON m.child_name = u.user_name
JOIN (
SELECT *
FROM JIRA.cwd_user_attributes ca
WHERE attribute_name = 'login.lastLoginMillis'
) a ON a.user_id = u.ID
JOIN JIRA.cwd_directory d ON u.directory_id = d.ID
order by last_login_date desc; 

Crowd DB sql : 

select cwd_user.user_name,cwd_directory.directory_name, TO_DATE('19700101','yyyymmdd') + ((cwd_user_attribute.attribute_value/1000)/24/60/60) as last_login_date
from CROWD.cwd_user_attribute, CROWD.cwd_user, CROWD.cwd_directory
where cwd_user_attribute.user_id = cwd_user.id AND cwd_user.directory_id = cwd_directory.id AND cwd_user_attribute.attribute_name = 'lastAuthenticated'
ORDER BY last_login_date desc

 

1 answer

0 votes
Furkan Ekin Eren March 25, 2020

Merhaba Can Bey,

Aynı sıkıntı ile karşılaştım acaba siz çözüme ulaşabildiniz mi?

Suggest an answer

Log in or Sign up to answer