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!

0 Comments   [ + ] Show comments

Answers (2)

Posted by: TheITNooB 1 month ago
Orange Belt

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


Posted by: JasonEgg 1 month ago
Red Belt

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'

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ