Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to get active users list with lastlogin time and jira group with Groovy script

I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 5, 2019

Can any one help me on the Groovy script 

following details needed

-user name


-lastlogin time

-groups (ex: Jira users,Admins...) 

1 answer

0 votes
Dawn Cooper November 11, 2021

I have this when using Crowd

SELECT d.directory_name AS "Directory",

    u.user_name AS "Username",

    FROM_UNIXTIME((CAST(attribute_value AS UNSIGNED)/1000)) AS "Last Login"FROM cwd_user u

    JOIN cwd_directory d ON u.directory_id =

    LEFT JOIN cwd_user_attributes ca ON = ca.user_id AND ca.attribute_name = 'login.lastLoginMillis'WHERE = 1AND = 1AND u.lower_user_name IN (SELECT DISTINCT lower_child_name

            FROM cwd_membership m

            JOIN licenserolesgroup gp ON m.parent_name = gp.GROUP_ID)AND ( IN (SELECT ca.user_id

            FROM cwd_user_attributes caWHERE attribute_name = 'login.lastLoginMillis' AND FROM_UNIXTIME(ROUND(ca.attribute_value/1000)) <= (current_date - interval 60 day))OR NOT IN (SELECT ca.user_id

            FROM cwd_user_attributes caWHERE attribute_name = 'login.lastLoginMillis'))ORDER BY "Last Login" DESC;

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events