Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
-- 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;