is it possible to find all boards connected to an inactive user with groovy?

Tomas Gustavsson_mf0n45

Currently i have a script the gives me all inactive users, 

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.user.util.UserManager

// all inactive jira users
UserManager userManager = ComponentAccessor.getUserManager()
userManager.getUsers().findAll{user -> !user.isActive()}.each { user ->
//...
}

Now i would like to find out if the inactive user also has a board that i can remove, somewhat as below but with groovy. any ideas?

Andrew

Hi @Tomas Gustavsson ,

You can find it direct from DB.

SELECT * FROM ao_60db71_rapidview where owner_user_name='andrewdvizhok';

How request to DB from scriptrunner I already write here https://community.atlassian.com/t5/Jira-questions/get-all-category-created-in-jira/qaq-p/1084797

 

But unfortunately I don't know how delete it through scritrunner. I prefer use selenium to delete boards/schemes/etc in UI, because delete direct from DB or scriptrunner may break system.

B.R.