How to Retrieve a List of Private Filters or Dashboards

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Purpose

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.

Solution

  1. Login to the JIRA database.
  2. 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');

Last modified on May 1, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.