Snippets

Jonathan Hult Jira - SQL - user last active report

Created by Jonathan Hult
SELECT cwd_user.user_name AS "User (email)", 
		to_timestamp(CAST(cwd_user_attributes.attribute_value AS bigint) / 1000) AS "Last Active"
FROM 
	cwd_user, cwd_user_attributes 
WHERE 
	cwd_user_attributes.user_id = cwd_user.id 
AND 
	cwd_user_attributes.attribute_name = 'login.lastLoginMillis'
ORDER BY 
	"Last Active" DESC;

Comments (1)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.