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
Merhaba Can Bey,
Aynı sıkıntı ile karşılaştım acaba siz çözüme ulaşabildiniz mi?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.