/build/static/layout/Breadcrumb_cap_w.png

Placed image in an email via a sql rule.. broken link

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.  


Ticket: $ticknum
From: $submitter_name
Category: $category
Priority: $priority
Status: $status
Opening Comment: $comment 


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%.%")) 


0 Comments   [ + ] Show comments

Answers (1)

Posted by: barchetta 2 weeks ago
Third Degree Brown Belt
0

C'mon @hobbsy :)   throw me a bone :).  I suspect this is not possible right?

Don't be a Stranger!

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

Sign up! or login

Share

 
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