This article explains how to run an SQL query in Oracle Database to identify dashboards that use Rich Filter gadgets in a Jira Server/Data Center instance.
Run the below Query query in the Oracle database to get the list of dashboards that use the Rich Filter gadgets.
...
The SQL query above will return the list of dashboard which dashboards that use at least one rich filter gadget. For each dashboard, the query returns the dashboard idID, dashboard name, dashboard owner, the id ID, and the name of the rich filter used in that dashboard. The same rich filter can be used in multiple dashboards and each dashboard can use multiple rich filters, there is an n-to-n relationship between dashboards and rich filters.
...