How to list all boards and filters owned by inactive users in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
As an Admin you may want a list of all the boards and filters which are owned by inactive users.
Jira doesn't provide an UI functionality for this, so this article presents an alternative by querying the database directly.
Environment
Any version of Jira 7.x, 8.x, 9.x.
Solution
The queries below are examplesbuilt on Postgres syntax that you may need to adapt to your particular database:
Warning:
If a username has multiple entries across directories, with at least one entry marked as inactive, SQL queries may incorrectly identify the user as inactive. To ensure accuracy, check the user's active status by referring to How to list all Users and Groups in Jira.
Boards
1
2
3
4
SELECT rv."NAME" AS boardname, ba."KEY" AS owner_user_key, cu.user_name AS owner_user_name FROM "AO_60DB71_BOARDADMINS" ba
INNER JOIN app_user au ON ba."KEY"=au.user_key
INNER JOIN cwd_user cu ON au.lower_user_name=cu.lower_user_name INNER JOIN "AO_60DB71_RAPIDVIEW" rv ON ba."RAPID_VIEW_ID"=rv."ID"
WHERE cu.active=0;Filters
1
2
3
4
SELECT sr.filtername, sr.authorname AS owner_user_key, cu.user_name AS owner_user_name, sr.reqcontent AS JQL FROM searchrequest sr
JOIN app_user au on sr.authorname=au.user_key
JOIN cwd_user cu on au.lower_user_name=cu.lower_user_name
WHERE cu.active=0;Was this helpful?