Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,301,516
Community Members
 
Community Events
165
Community Groups

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

-mailid

-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 = d.id

    LEFT JOIN cwd_user_attributes ca ON u.id = ca.user_id AND ca.attribute_name = 'login.lastLoginMillis'WHERE u.active = 1AND d.active = 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 (u.id 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 u.id 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
TAGS
Community showcase
Published in Apps & Integrations

📅 Partner Webinar & Events Opportunities: July 2022

Hi community 👋, Here is another monthly roundup of the partner-organized events in July 2022. If there is any event missing please let me know in the comments below 🙏 If you're looking for Atla...

29 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you