I am looking for a way to pull out the attachment link to include in ticket reports from Support. If anyone has a way to do this it would be highly appreciated.

What I am looking for is to include links for all attachments in a ticket as a separate column. So I have i.e. the following information:

Ticket ID - Reason dropdown value - Product dropdown value - link to image attachments customer sent in

Been trying to look for a way to do this, but I'm getting stuck. At the moment agents are manually adding links to a shared file, which is sort of a mess to sort out when preparing reports for some delivery partners.