How to Retrieve a List of Private Filters or Dashboards
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
目的
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.
ソリューション
The content on this page relates to platforms which are supported; however, the content is out of scope of our Atlassian Support Offerings. Consequently, Atlassian cannot guarantee support. Please be aware that this material is provided for your information only and you may use it at your own risk.
- 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');