Versions Compared

Old Version 4

changes.mady.by.user Cao Liang

Saved on

compared with

New Version 5

changes.mady.by.user Hua Soon SIM [Akeles]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

MySQL

Code Block
languagesql
-- 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;

PostgreSQL

Code Block
languagesql
-- 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;

...