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

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!

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 Join to answer
Community showcase
Jason Wong
Published 6 hours ago in Agility Beta

Welcome to agility

Every team in the world is unique, and so   Atlassian believes   that each and every team's best way of working  needs to  be molded to their unique circumstances  – ...

143 views 3 10
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot