Cleaning up Resolutions and Statuses

[Adam_G]

I am attempting to consolidate two separate instances of Jira Software into one and would like to trim Resolutions and Statuses to only be those currently in use. When I go to delete an unused resolution/status, it will give me the number of issues, but does not tell me that its used by X filters, Y dashboards, or Z workflow post functions. Is there any way to find this information easily?

[Jack Brickey · Accepted solution]

yep, you won't get that info. I don't know of any way to gather this automatically. Manual scrub and then wait for someone to report something not working.

[Adam_G]

I think I actually figured it out using Postgres. There's probably an easier way, but this is how I did it:

1. Get Resolution IDs
   1. go to the admin console, hover over the edit button on a resolution, and write down the number (Step 2) and the name (Step 3)
2. Find Workflows that use that Resolution ID

   1. Do a SQL query for what you're looking for. for me, it was something like:

   2. SELECT workflowname 
      FROM JIRAWORKFLOWS
      WHERE DESCRIPTOR LIKE '%<arg name="field.name">resolution</arg>
      
                   <arg name="full.module.key">com.atlassian.jira.plugin.system.workflowupdate-issue-field-function</arg>
      
                   <arg name="field.value">10</arg>%';

   3. There is your list of workflows that are impacted if you delete a resolution.

3. Find Filters that use that Resolution
   1. Do a SQL query for impacted filters

   2. SELECT *
      FROM searchrequest
      WHERE reqcontent LIKE '%resolution = %'
      AND reqcontent NOT LIKE '%resolution = Unresolved%'
      AND reqcontent NOT LIKE '%resolution = unresolved%'
      AND reqcontent NOT LIKE '%resolution = \"Old Resolution I want to get rid of%'

   3. There is your list of filters that are impacted if you delete a resolution.

[Hubert Kut]

Hi @Adam_G 
For cleanup custom fields, data management, Jira administration and much more I would recommend to give a try to our app.
Doctor Pro: Audit, Optimize & Manage Configuration for Jira
https://marketplace.atlassian.com/apps/1231705/doctor-pro-audit-optimize-manage-configuration-for-jira?hosting=cloud&tab=overview

If you have any questions feel free to reach out to us!
Best
Hubert