I use a code very similar to this one linked, to send New Ticket emails to our IT department.
http://www.itninja.com/blog/view/issue-with-sql-code-kace-service-desk-new-ticket-notification-email

Is there a way to modify this line:

'helpdesk@mycompany.com' AS NEWTICKETEMAIL -- $newticketemail

FROM HD_TICKET

So that i could include the emails in the CC field as well?

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
The CC field is stored in the CC_LIST column so if you can select it in the rule and use CC_LIST as the email column. If you want to email both helpdesk@mycompany.com and the addresses in the CC_LIST column then you would use the following:
concat_ws(',', 'helpdesk@mycompany.com', CC_LIST) AS NEWTICKETEMAIL


Answered 08/01/2014 by: chucksteel
Red Belt

  • Got the following error:
    mysql error: [1052: Column 'CC_LIST' in field list is ambiguous] in EXECUTE("SELECT -- ticket fields HD_TICKET.ID AS TICKNUM
    • Right. HD_CATEGORY also has a CC_LIST column and it's also included in the query. I should have specified HD_TICKET.CC_LIST.
      • Got it working now! Thanks very much for your help!
Please log in to comment
Answer this question or Comment on this question for clarity