How to find usage for each Issue Link Type in Jira Data Center / Server
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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.
*Except Fisheye and Crucible
Summary
As an admin, you may be interested in the usage of each specific Issue Link Type on your instance to either drive a cleanup or to better understand the usage.
Environment
Tested on Jira 8 and Jira 9.
Solution
It's possible to fetch this information directly from the database. The query was tested on PostgreSQL; other products may require you to add database schema or remove double quotes:
The result will include issue links associated with archived issues.
1
2
3
4
5
6
7
8
9
10
11
12
13
select count(*),
il.linktype,
ilt.linkname,
ilt.inward,
ilt.outward,
ilt.pstyle
from "issuelinktype" ilt
join "issuelink" il on il.linktype = ilt.id
group by il.linktype,
ilt.linkname,
ilt.inward,
ilt.outward,
ilt.pstyle;You may also be interested in finding specific issues with most Issue Links. For that, you can refer to the article below:
Here's the official documentation for Issue Linking in Jira:
Was this helpful?