Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Unused Filters - any way to see which filters are *not* being used in dashboard gadgets?

Kim-Stacey Kidder February 24, 2023

Hi! Is there a way (ex: report? overview?) to see which filters are being used in particular dashboards (& also to see which filters are not being used in dashboards) without having to check each gadget?
We're finding that dashboards are updated frequently & it takes quite a bit of time to go through every dashboard gadget individually to find the corresponding filter/s.
This would also greatly help us with data clean-up. 

Thanks in advance for any ideas! 

 

6 comments

Comment

Log in or Sign up to comment
Eric Yanou February 24, 2023

I'm also curious to find out

Kristján Mathiesen February 24, 2023

Me 2

Johnny FromCanada February 24, 2023

You could try to "delete" the filter (probably via admin account).  Obviously, do not commit to the deletion.  See if it warns about being used in a certain number of places.

Jean Ann Harrison February 24, 2023

Isn't it possible to archive filters rather than deleting?   This way, they can be restored when needed.  

Lorenzo Phillips
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 24, 2023

@Kim-Stacey Kidder

I don't believe theirs is a way to determine if filters are being in that way. However, I wrote an app that allows you to see all filters in your instance and you can export them all or some subset to have discussions with the filter owner to determine if a filter can be removed. My app has a View Permissions column that I use to determine which Projects and/or Groups are using the filter. I know this isn't exactly what you may want, but it does provide some additional help. :) Finally, my app allows you to delete filters in bulk instead of one at a time. 

Of course your feedback is always welcomed: Instance Auditor (Jira)

Like # people like this
Hugo Navia February 24, 2023

Hi Kim,

If this is a Server/DC instance and if you have access to the DB, you could try the following SQL query:

select * from searchrequest where id not in (select "SAVED_FILTER_ID" from "AO_60DB71_RAPIDVIEW");

 

Please note that this will give you ALL the filters that doesn't belong to a dashboard.

EDIT

My bad, I just noticed that this is for Cloud. You might be able to use REST API to get the list. However, this will not give you the private filters.

Like Kim-Stacey Kidder likes this
Lorenzo Phillips
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 24, 2023

My app provides all filters in the system, even ones you don’t have permission to. 😎

Like # people like this
TAGS
AUG Leaders

Atlassian Community Events