You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
we are using Crowd for user authentication and SSO for confluence and jira. We have limited user licencse for all tools. We need to alert users who are not logged in for more than 30 days by email and admin should be able to get the list those users and there should be an option for admin to deactivate those users. is there any plugins/options available for this task?
Hello Ramesh,
On the Crowd database, you could run the following query to get a list of all users that have not logged-in in the last 30 days:
SELECT cwd_user.user_name AS 'User', DATEDIFF(DAY, DATEADD(s, FLOOR(CAST(cwd_user_attribute.attribute_value AS BIGINT) / 1000), '1970-01-01'), GETDATE()) AS 'Days since last login > 30' FROM cwd_user, cwd_user_attribute WHERE cwd_user_attribute.user_id = cwd_user.id AND cwd_user_attribute.attribute_name = 'lastAuthenticated' AND DATEDIFF(DAY, DATEADD(s, FLOOR(CAST(cwd_user_attribute.attribute_value AS BIGINT) / 1000), '1970-01-01'), GETDATE()) > 30
You could set up a job that runs every night and sends out an e-mail to users and administrators as soon, as the list returns some results.
Hope this helps.
Cheers,
Thomas
This doesn't seem to work with Jira/Crowd, it seems to report only few accounts ~10 instead of overt >200 which did succesfully loing (based on logs). It may be related to LDAP/AD/crowd usage as all reported accounts seems to be local ones, and missing ones are the LDAP/AD/crowd ones.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Thomas,
Need a help,
We need to find out users from jira who have not logged in since last 30 days,
We use oracle database at the backend, but i am not familier with the oracle db,We use jira 5.2.8 standalone version.
Can you please suggest how can i proceed.
Regards,
Moiz.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I tested a JIRA plugin a while back, might be what you're looking for: https://marketplace.atlassian.com/plugins/com.riadalabs.jira.plugins.userdeactivator
BR,
/Roine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Happy New Year! We hope you all had a safe and restful holiday season. 2020 was a unique year full of unforeseen events; however, as we enter the new year of 2021, we’re optimistic for the light at t...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.