Resolution Clean up

[Nivine Alaeddine]

I am attempting to do some instance clean up on the instance. When I go to delete an unused resolution, 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 via SQL?

[Kristopher Perez]

I have found the actual Atlassian Support to be really helpful when it came to looking for specific queries like this.  They have their own library and KB for all sorts of different SQL queries to help out, so I would actually start with opening up a request for support and ask them.

https://support.atlassian.com/contact/#/

I'm no longer on a Data Center environment, but the most recent help I needed from them involved querying every Service Desk in our environment (a total of 180) for mismatched Confluence Portals.

If you get the answer, please make sure to post here, I'm sure others will appreciate it.

Kris