Remove Jira Users from MSSQL Backed Instance

remove_jira_users.sql

DECLARE @UserList TABLE (USERNAME NVARCHAR(255))
INSERT INTO @UserList VALUES ('user.name')
/*add additional 
INSERT INTO @UserList VALUES ('<user name here>') 
statement to batch remove multiple users
*/

DECLARE @COUNTER INT = 0
DECLARE @USERCOUNT INT = (SELECT COUNT(*) FROM @UserList)

WHILE @COUNTER < @USERCOUNT
BEGIN

DECLARE @CUR_USER NVARCHAR(255)
DECLARE @CUR_USER_ID NUMERIC

SET @CUR_USER = (SELECT USERNAME FROM
      (SELECT (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) [index] , USERNAME from @UserList) R 
       ORDER BY R.[index] OFFSET @COUNTER 
       ROWS FETCH NEXT 1 ROWS ONLY);

SET @CUR_USER_ID = (select ID from Jira.jiraschema.cwd_user where user_name = @CUR_USER)
delete from Jira.jiraschema.cwd_user_attributes where user_id=@CUR_USER_ID
delete from Jira.jiraschema.cwd_membership where child_name=@CUR_USER
delete from Jira.jiraschema.cwd_user where user_name =@CUR_USER 
delete from Jira.jiraschema.app_user where id =@CUR_USER_ID

SET @COUNTER = @COUNTER + 1

END