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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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,560,340
Community Members
 
Community Events
185
Community Groups

Is there any inactive user management plugins available?

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?

4 answers

2 votes
Thomas Wendel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 15, 2011

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

Sorin Sbarnea (Citrix)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jan 06, 2013

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.

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.

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

Hello Roine,

Thanks for your great help, :)

cheers,

Moiz

In the first step admin user of the site setup days of inactivity and drafting notification mail for all users from the Site administration > Reports > Inactive User Cleanup

If an inactive user is found he/she gets a notification mail.

In second step if the user still has not accessed the moodle site within the time span which is mentioned in the notification mail. Then the deletion process starts. The particular inactive user account entry is removed with next run of this cleanup process which is automatically or manually run by cron process.

Using

Some setting is require for this cleanup process.

Setting Panel

Days of Inactivity is set by the admin user.

Days Before Deletion is set with zero when admin just wants to notify the inactive user for access the site i.e. in first step. After that when user wants to run cleanup process then Days Before Deletion will set by the admin user.

Email setting

Admin user must set the subject and body text of the email.

Cron process

Admin user run cron job manually from http://<moodlename>/admin/cron.php

Uninstall

Admin can uninstall this admin tool from Site administration > Plugins > Admin tools > Manage Admin Tools

Hi,

Is there a plugin similar for Bitbucket?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events