Can anyone tell me how to get a Kace Service Desk SELECT statement to return a ticket's URL?
I don't see a URL field in any of the HD* tables??
Thanks
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
There isn't an explicit URL field in the table, you need to generate it yourself as part of the email message and use the HD_TICKET.ID field for the ticket ID to append to the URL for your KBOX. If your select statement gets HD_TICKET.ID as TICKETID, then in the email message you would include: http:///adminui/ticket.php?ID=$ticketid
There isn't an explicit URL field in the table, you need to generate it yourself as part of the email message and use the HD_TICKET.ID field for the ticket ID to append to the URL for your KBOX. If your select statement gets HD_TICKET.ID as TICKETID, then in the email message you would include: http:///adminui/ticket.php?ID=$ticketid
Please log in to answer
Posted by:
chucksteel
11 years ago
There isn't an explicit URL field in the table, you need to generate it yourself as part of the email message and use the HD_TICKET.ID field for the ticket ID to append to the URL for your KBOX.
If your select statement gets HD_TICKET.ID as TICKETID, then in the email message you would include:
http://<your KBOX servername>/adminui/ticket.php?ID=$ticketid
Comments:
-
Thanks! So obvious... sigh. - kpm8 11 years ago
Posted by:
Aaron Cool
11 years ago