How can I search for all URLs in Jira?

Question

I want a list of all the URLs in Jira so I can then organise them to find specific URLs that point to docs on our gdrive. We have now moved to Egnyte and need to relink them to Egnyte (unless there is a way to map the docs from gsuite to Egnyte. Any help would be appreciated. Thanks :)

Tarun Sapra · Answer

My second suggestion was for server (you can take cloud backup and restore on server)

Bachittar_Singh · Answer

Is this the case even if it's Cloud based? What's the best way to grep through it? And links etc I'd be happy to follow. Never really done this before or messed with dBs apart from using SQLLite

Tarun Sapra · Answer

Hello @Bachittar_Singh

Jira stores data in structured format thus in order to search for anything you need to use JQL and provide relevant fields in query. Thus, which field in jira tickets was storing the URLs? As you need to search in that field instead of going through each field of the JIra.

Another option you have is to take a DB dump and grep through the whole dump to find the URLs, this should also do the trick.