MySQL
Code Block |
---|
-- 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 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-users' order by ua.attribute_value; |
...