Hi

On some of the reports the results include a clickable/hyperlink to the URL that opens the ticket when you click on it.

How can I get that in an SQL query format? So that when I query the servicedesk DB one of the columns has a link to go directly to the ticket and not just list the ticket number.