Bulk delete users

When I imported a redmine project into jira, all the the redmine project users were unexpectedly created in our jira instance. I now need to delete 100+ users. Can I mass delete these new users somehow?

Thanks!

Yen

5 answers

1 accepted

0 votes
Anna Cardino Atlassian Team May 21, 2014

Hi Yen,

It would be safer to use JIRA Command Line Interface removeUser action. UserunFromSql to do it in bulk. Doing database actions directly is error prone and you need to understand all the application's database structure. The dangers of doing direct database actions have been commented on numerously on this site.

Hope it helps.

Monique

Thanks Monique - I did see this answer but I was hoping there was an option within the ondemand instance where I can just check box names and delete them.

0 votes

Another possible alternative to delete users programatically is writing a script and using the JIRA REST API:

The feature request raised for bulk user delete operations in JIRA is https://jira.atlassian.com/browse/JRA-8047, and you may vote on it to increase its visibility with our developers.

 

I know I'm a little late but you could also explore using Jelly scripts.

 

https://confluence.atlassian.com/display/JIRA/Jelly+Tags#JellyTags-jira:RemoveUser

And deleted :)

Write a little js code as follows and run it in Chrome after logging into the Admin console.  

var baseURL = "https://mycompany.atlassian.net//admin/rest/um/1/user?username=";

function deleteUser(userId) {
var xhttp = new XMLHttpRequest();
xhttp.open("DELETE", baseURL+userId, true);
xhttp.send();
console.log(responseText);
}

function bulkDelete() {
var usersToDelete = ["user1", "user2", "user3"];
for (var i=0; i< usersToDelete.length; i++) {
deleteUser(usersToDelete[i];
}

}

I wrote a little bash script which accepts a file with a list of usernames, then runs curl to call the API to delete each user.

Usage:

$ cat foo
ninja
$ ./jiracmd-user-delete foo
Jira Base URL:https://jira.uwo.ca
Username:aculver
Password:
ninja: {"errorMessages":["Cannot delete user 'ninja' because 12 issues were reported by this person.","Cannot delete user 'ninja' because they have made 11 comments."],"errors":{}}

If the delete was successful, you'll see a line reading "username:"

If the delete failed, you'll see "username: {json containing error message}"

Script:

#!/bin/bash

# CONFIG
# Give these values to skip prompts

adminuser=
jira=

# END CONFIG

if [ $# -ne 1 ]; then
echo "Usage: $0 infile"
exit 1
fi

infile=$1
if [ ! -r $infile ]; then
echo "Can't read file: $infile"
exit 1
fi

if [ -z $jira ]; then
echo -n "Jira Base URL:"
read jira
fi

if [ -z $adminuser ]; then
echo -n "Username:"
read adminuser
fi

echo -n "Password:"
read -s adminpass
echo

cmd=DELETE
api=/rest/api/2/user

while read u; do
echo -n "$u: "
curl --insecure --silent --show-error -u $adminuser:$adminpass -X $cmd -H "Content-Type: application/json" "$jira$api?username=$u"
echo
done < $infile

 

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,899 views 12 18
Join discussion

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