How can I display a ticket link in a KACE report?
I know how to display a ticket link in an email, but is there a way to display a ticket link in a KACE report? Thank you!
Does this help? In your reports for tickets > Fields to Display > Ticket Info > Check "Ticket ID"
Then in the Colum Order Section have "Ticket ID" at the top of the list. This will display the Ticket ID # in the report and offer the hyperlink for the tickets in the reports. This is an HTML report example
If you're running a SQL report rather than a report from the wizard you can use this to generate a URL:
works but not a true hyperlink: CONCAT('https://your.kbox.com/userui/ticket.php?ID=',HD_TICKET.ID) as 'Ticket URL'
You may be tempted to do something like this to create an actual hyperlink but it doesn't work since KACE sanitizes the HTML report:
HTML in SQL doesn't work: CONCAT('<a href="https://your.kbox.com/userui/ticket.php?ID=',HD_TICKET.ID,'">','https://your.kbox.com/userui/ticket.php?ID=',HD_TICKET.ID,'</a>') as 'Ticket URL'