How to Retrieve a List of Private Filters or Dashboards
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
Since JIRA Administrator is not able to view or modify private filters and dashboards, it would be a blocker if someone left the company and you would like to know what is under the user account. Those private filters and dashboards will not be shown under Shared Filters or Shared Dashboards. This KB will document the SQL queries that can retrieve a list of private filters and dashboards.
- Login to the JIRA database.
- Run the following SQL accordingly:
For private dashboard:
select * from portalpage where id not in (select entityid from sharepermissions where entitytype='PortalPage');
For private filter:
select * from searchrequest where id not in (select entityid from sharepermissions where entitytype='SearchRequest');