Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

Can any one help me on the Groovy script 

following details needed

-user name


-lastlogin time

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

1 answer

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