KACE Product Support

Im running into an issue where I have a notification email sending via a script and the pasted image inside the ticket is showing as a broken link.  Comments inside the ticketing system work fine but its that initial notification email that its broke on.  I dont know if the "canned" emails work or not as its been so long since Ive used them.  Below is my script..  its the $comment inside the email thats broken.  Is there some way I can include the attachment?

Resulting Email HTML: src="/packages/hd_attachments/screenshot_xhlxg79fk.png.56e222d23c5cb94d1e8cbaba0e095cff" alt="image"  this appears to the problem....  the html seems malformed.  

EMAIL CONFIG IN THE KACE RULE:

A ticket has been opened or moved into the $queue_name queue.  

SCRIPT

SELECT 

HD_TICKET.CREATED, 

HD_PRIORITY.NAME AS PRIORITY, 

HD_TICKET.TITLE, 

HD_TICKET.ID AS TICKNUM, -- $ticknum

HD_CATEGORY.NAME AS CATEGORY, 

C.COMMENT,

C.DESCRIPTION,    

S.FULL_NAME AS SUBMITTER_NAME,     

Q.NAME AS QUEUE_NAME, 

O.FULL_NAME AS OWNER_NAME, 

HD_TICKET.ID as TOPIC_ID , CONCAT('TICK: ', HD_TICKET.ID) AS Number,

OLIST.EMAIL AS NEWTICKETEMAIL, -- $newticketemail

CAT.NAME AS CATEGORY, -- $category

HD_STATUS.NAME AS STATUS

FROM 

HD_TICKET 

LEFT JOIN USER SUBMITTER ON SUBMITTER.ID = HD_TICKET.SUBMITTER_ID

JOIN HD_TICKET_CHANGE C ON C.HD_TICKET_ID = HD_TICKET.ID 

AND C.ID=<CHANGE_ID>

LEFT JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID) 

LEFT JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID) 

LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) 

JOIN HD_QUEUE Q ON Q.ID = HD_TICKET.HD_QUEUE_ID 

LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) 

LEFT JOIN MACHINE ON (MACHINE.ID = HD_TICKET.MACHINE_ID) 

LEFT JOIN HD_SERVICE_STATUS ON HD_TICKET.HD_USE_PROCESS_STATUS 

and HD_TICKET.HD_SERVICE_STATUS_ID 

and HD_SERVICE_STATUS.ID = HD_TICKET.HD_SERVICE_STATUS_ID 

LEFT JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) 

JOIN HD_CATEGORY CAT ON CAT.ID=HD_CATEGORY_ID

LEFT JOIN HD_CATEGORY CTEXT ON (CTEXT.ID = HD_TICKET.HD_CATEGORY_ID) 

 /* group email     */

JOIN HD_QUEUE_OWNER_LABEL_JT ON HD_TICKET.HD_QUEUE_ID = HD_QUEUE_OWNER_LABEL_JT.HD_QUEUE_ID

JOIN USER_LABEL_JT ON HD_QUEUE_OWNER_LABEL_JT.LABEL_ID = USER_LABEL_JT.LABEL_ID

JOIN USER OLIST ON USER_LABEL_JT.USER_ID = OLIST.ID

/* queue */

JOIN HD_QUEUE ON HD_TICKET.HD_QUEUE_ID = HD_QUEUE.ID

WHERE

HD_STATUS.NAME != 'Closed'

AND HD_STATUS.NAME not LIKE '%HOLD%'

AND HD_TICKET.HD_QUEUE_ID = 1 

AND (C.DESCRIPTION LIKE '%CREATED%' OR C.DESCRIPTION LIKE concat("%Changed ticket Queue from%to%.%"))