How to inactive internal users in bulk?

Our regular Jira (and Confluence) users all come from the Active Directory. However, when a person leaves the compan (and disappears from corporate AD), we create an account in the internal directory and mark them inactive. That's the theory, but in practice a number of users linger in the internal directory while remaining "active"...

Can we mark all users currently in the internal directory as inactive somehow? Or do we have to do one at a time? Thanks!

2 answers

This widget could not be displayed.

Are you running Jira/Confluence in OnDemand or are you hosting yourself?

Self-hosted... I don't think, OnDemand can even integrate with the customer's Active Directory, can they?

Just asking to make sure...some folks think the OnDemand Crowd management is LDAP.

Jira (run through test first):

update cwd_user

set active = 0

where lower_user_name in ('')


update cwd_user

set active = 'F'

where lower_user_name in ('')

You can add additional constraints as well such as directory_id if you have multiple directories, or you want it to just apply to everything in one directory.

Make sure you exclude your admin user/s from any internal directory deactivations, otherwise you'll feel some pain.

Oh, but that's going through database... Yes, I know this method -- but a Jira restart is needed afterwards (because user info is cached by the app, I believe).

I was hoping for a way to do the same through the application... Is there anything? Thanks!

This widget could not be displayed.

I use Script Runner in Jira a lot for bits. Hypothetically, you may be able to do it that way. Jamie built one for Confluence as well, but I haven't used it. You'd have to develop your own script for that as I don't have one handy for what you are looking to do.

Otherwise, you are doing them one at a time or through the database. There maybe other plugins, but you'd have to take a look for them.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published 7 hours ago in Bitbucket

Branch Management with Bitbucket

As a project manager, I have discovered that different developers want to bring their previous branching method with them when they join the team. Some developers are used to performing individual wo...

36 views 0 5
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you