Skip to content

Instantly share code, notes, and snippets.

@mrw

mrw/gist:ea1c3e7c506fce61dd8f

Last active August 29, 2015 14:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrw/ea1c3e7c506fce61dd8f to your computer and use it in GitHub Desktop.
Save mrw/ea1c3e7c506fce61dd8f to your computer and use it in GitHub Desktop.
Download ZIP
JIRA users by login time
Raw
gistfile1.sql
SELECT
user_id,
user_name,
email_address,
from_unixtime(attribute_value / 1000) AS last_login_time
FROM
cwd_user_attributes
INNER JOIN cwd_user
ON cwd_user_attributes.user_id = cwd_user.ID
WHERE
attribute_name = 'login.lastLoginMillis'
AND active = 1
ORDER BY
last_login_time ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment