How to perform a cleanup and identify rich filters that haven't been used or updated in a long time

This article provides an SQL query to identify where rich filters are being used, helping teams plan cleanup activities and remove rich filters before migrating to the cloud.

Instructions

Since version 2.2.0 of the Rich Filters app, each rich filter has a “last used date” stored in the database. The timestamp updates whenever a filter is edited or loaded in a dashboard. Although the DC UI doesn't show this field, you can query it directly from the database.

SELECT
    "ID",
    "NAME",
    "JIRA_FILTER_ID",
    to_timestamp("LAST_USED_DATE" / 1000.0) AS last_used
FROM "AO_24D977_QRFRFE0"
ORDER BY "LAST_USED_DATE" ASC NULLS FIRST;

This returns:

Filters with no recorded usage date appear first.
The least recently used filters appear next.
The most recently used filters appear last.

Example output: