How to find the pages which has Jira links present in it for a specific space.
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
This KB will help us to find the pages which have Jira links present in them for a specific space in Confluence.
Solution
The database query shared below will help us fetch the results
Select c.* from BODYCONTENT b, CONTENT c
WHERE
c.contentid=b.contentid and
c.spaceid='<spaceid>' and
b.body LIKE '%<JIRA_URL>%';