Can someone help me with the steps to remove some users from all the group and projects in JIRA using SQL statements. we are having JIRA 4.4.1 version and using sql server 2008 db.
appriciate your help
If you try to remove them with SQL, you'll need Jira offline while it's running, a re-index afterwards, you're open ot unexpected problems and data corruption, and you will have to back up properly and test the backup before you do this.
On the SQL side, I can name 8 tables you'll need to worry about (2 of which are not simple "remove/blank data" actions) without resorting to notes which I think tell me there's something like 17 tables to check and amend.
Rather than jump at a solution, could you tell us what you're actually trying to do, and why the UI isn't appropriate?
SQL is still a really bad way to approach this and it's pretty certain that you'll break something, unless you spend weeks getting your scripts exactly right.
You must already have the list of users to remove if you were thinking of using SQL, so you should take that and convert it to Jelly (this is easy with a spreadsheet or script) and run that instead. Jelly uses the internal API to do the work, so it won't break anything and doesn't need downtime.
That's a lot more simple. I think the table you need is cwd_membership.
If you're going to execute SQL updates of any kind on a Jira system, then the procedure is:
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG