Is there a way to search for all pages with a Jira Issue link?

[Mya.Hauck]

We are working on a migration between two Atlassian sites. We are about to move Confluence pages over from one site to our main site. I want to make sure I am catching all Jira Issue links within their Confluence, so that I can go in and change them once their Jira issues get moved over to our Jira site and the links change.

Does anyone know of a way to search for all Confluence pages that contain any Jira issue links?

Thanks

[Kishan Sharma]

Hi @Mya.Hauck you will need to run SQL queries on your database to get this information. Please refer this link for details. Please accept the answer if you have found this useful.

[Mya.Hauck]

Is this possible in Cloud? Looks like this doc is for Server. 

Thanks

[Kishan Sharma]

On cloud you can can explore REST API to see if you can get those details. Refer -https://developer.atlassian.com/cloud/confluence/rest/api-group-search/#api-wiki-rest-api-search-get