Finding User Login Information

-- User login information
SELECT u.user_name, u.display_name, u.email_address, 
FROM_UNIXTIME(CONVERT(ua.attribute_value/1000, UNSIGNED INTEGER),'%T %m/%d/%Y') AS lastlogin, g.group_name 
FROM cwd_user u, cwd_group g, cwd_membership m, cwd_user_attributes ua 
WHERE u.id = m.child_id AND m.parent_id = g.id AND u.id = ua.user_id 
AND ua.attribute_name = 'login.lastLoginMillis' AND g.group_name LIKE 'jira-administrators' 
ORDER BY ua.attribute_value;

-- User login information
SELECT u.user_name, u.display_name, u.email_address, 
TO_TIMESTAMP(ua.attribute_value::BIGINT/1000) AS lastlogin, g.group_name 
FROM cwd_user u, cwd_group g, cwd_membership m, cwd_user_attributes ua 
WHERE u.id = m.child_id AND m.parent_id = g.id AND u.id = ua.user_id 
AND ua.attribute_name = 'login.lastLoginMillis' AND g.group_name LIKE 'jira-administrators' 
ORDER BY ua.attribute_value;