Email to Distribution List
Hi,
We have a distribution list created in Exchange and set it up as a user account in KACE, not imported from AD, but when we try to set it as an owner, no email goes out to the distribution list.
We would like to set it up if a ticket is created it notifies a group of techs that a new ticket has been created and hasn't been assigned to anyone yet.
We have a distribution list created in Exchange and set it up as a user account in KACE, not imported from AD, but when we try to set it as an owner, no email goes out to the distribution list.
We would like to set it up if a ticket is created it notifies a group of techs that a new ticket has been created and hasn't been assigned to anyone yet.
0 Comments
[ + ] Show comments
Answers (7)
Please log in to answer
Posted by:
need2mod
12 years ago
Screenshot of what MoranTug stated above.
Comments:
-
need2mod + MoranTug,
THANK YOU! After two weeks of testing/configuration this was the final step to getting our distribution group working! - MAXintosh 8 years ago -
need2mod + MoranTug.
Amusingly I ran into this again two months after I originally found this answer. Once again it saved me. - MAXintosh 8 years ago
Posted by:
GillySpy
14 years ago
All other things being equal, a distribution list doesn't matter to the kbox. Try the email sending test from here: http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=676&artlang=en
If that works then please describe what you're trying to do because it is likely the kbox isn't even attempting to send to that address -- usually based on settings, etc
If that works then please describe what you're trying to do because it is likely the kbox isn't even attempting to send to that address -- usually based on settings, etc
Posted by:
KFox
12 years ago
I am having the same issue on our K1000. Emails of ticket changes go out to users, but if the ownership of the ticket is assigned to one of the distribution group users, nothing goes out. I would think that the K1000 wouldn't know a distribution group email address from a single user email address, but something is different.
Emailing is working fine...other than not notifying a distribution group of any ticket changes. We even have the group in the various CC lists, but nothing is going out.
We want a group of people notified about a ticket category, and then an individual can take ownership.
Emailing is working fine...other than not notifying a distribution group of any ticket changes. We even have the group in the various CC lists, but nothing is going out.
We want a group of people notified about a ticket category, and then an individual can take ownership.
Posted by:
GillySpy
12 years ago
cc list emails are driven by the checkboxes. Make sure they are set correctly.
I stole this query from here and modified it so you can see what the stakeholders should get. Run this against a specific ticket ID and if you're cc person is not in it then you must have configuration issue or an invalid email format or something. Note that this will combine all their emails into one entry so examine the TICKET_HISTORY column closely.
I stole this query from here and modified it so you can see what the stakeholders should get. Run this against a specific ticket ID and if you're cc person is not in it then you must have configuration issue or an invalid email format or something. Note that this will combine all their emails into one entry so examine the TICKET_HISTORY column closely.
select C.ID,
HD_TICKET.ID TICKET_NUMBER,
NOTIFIERS.EMAIL NOTIFY_USER,
P.NAME TICKET_PRIORITY,
HD_TICKET.TITLE TICKET_TITLE,
case when PV.VALUE<>'HIDE' then CONCAT('http://',KBOX.HOST,'/adminui/ticket.php?ID=',HD_TICKET.ID)
else CONCAT('http://',KBOX.HOST,'/adminui/ticket.php?ID=',HD_TICKET.ID) end TICKET_URL,
IFNULL(GROUP_CONCAT(DISTINCT CONCAT('----- Change by ', UPDATER.EMAIL,if(H.VIA_EMAIL=',',' (via email)'),' at ',cast(H.TIMESTAMP as char),' -----\n',
H.DESCRIPTION,'\n',H.COMMENT)
ORDER BY H.ID DESC SEPARATOR '\n'),'no user entries') TICKET_HISTORY,
P.ESCALATION_MINUTES TICKET_ESCALATION_MINUTES,
IFNULL(SUBMITTER.FULL_NAME,'unassigned') TICKET_SUBMITTER_NAME,
IFNULL(OWNER.FULL_NAME,'unassigend') TICKET_OWNER_NAME,
IFNULL(SUBMITTER.EMAIL,'unassigned') TICKET_SUBMITTER_EMAIL,
IFNULL(OWNER.EMAIL,'unassigend') TICKET_OWNER_EMAIL,
case when NOTIFIERS.ID=OWNER.ID then CONCAT(UPDATER.EMAIL,if(C.VIA_EMAIL=',',' (via email)'),' at ',cast(C.TIMESTAMP as char),'-----\n',
C.DESCRIPTION,'\n',C.OWNERS_ONLY_DESCRIPTION,'\n',C.COMMENT)
else CONCAT(UPDATER.EMAIL,if(C.VIA_EMAIL=',',' (via email)'),' at ',cast(C.TIMESTAMP as char),'-----\n',
C.DESCRIPTION,'\n',C.COMMENT) end CHANGE_DESC /* future goal: modify the owners to be based on owner label */
from HD_TICKET
JOIN HD_TICKET_CHANGE C ON C.HD_TICKET_ID=HD_TICKET.ID and C.ID>0
left JOIN HD_TICKET_CHANGE H ON H.HD_TICKET_ID=HD_TICKET.ID and H.OWNERS_ONLY=0
JOIN HD_PRIORITY P ON P.ID=HD_PRIORITY_ID
JOIN USER NOTIFIERS ON
/* notifiers is in the list */
(FIND_IN_SET(NOTIFIERS.ID,C.NOTIFY_USERS)>0 and
CONCAT(NOTIFIERS.EMAIL,',')
RLIKE '^([[:alnum:][.period.][.hyphen.][.underscore.]]+@([[:alnum:][.hyphen.][.underscore.]]+[.period.])+([[:alnum:][.hyphen.]]){2,4}[[.comma.]]+[[:space:]]*)+$' )
OR
/* email is in list and it's a valid address */
(FIND_IN_SET(NOTIFIERS.EMAIL,C.NOTIFY_USERS)>0 and
CONCAT(NOTIFIERS.EMAIL,',')
RLIKE '^([[:alnum:][.period.][.hyphen.][.underscore.]]+@([[:alnum:][.hyphen.][.underscore.]]+[.period.])+([[:alnum:][.hyphen.]]){2,4}[[.comma.]]+[[:space:]]*)+$' )
LEFT JOIN USER_ROLE_PERMISSION_VALUE PV ON PV.ROLE_ID=NOTIFIERS.ROLE_ID and PV.PERMISSION_ID=43
JOIN (select 'k1000' -- < change this value to your server name
HOST) KBOX ON 1=1
LEFT JOIN USER OWNER ON OWNER.ID=OWNER_ID
LEFT JOIN USER SUBMITTER ON SUBMITTER.ID=SUBMITTER_ID and C.OWNERS_ONLY=0
LEFT JOIN USER UPDATER ON C.USER_ID=UPDATER.ID
WHERE HD_TICKET.ID=7
Posted by:
MoranTug
12 years ago
Since Kace is not an authenticated network user, you have to go into the mail flow settings tab of the distribution list, select message delivery restrictions and UNCHECK the require that all senders are authenticated checkbox.
Comments:
-
Perfect. I've been racking my brain all day on this. I knew it was something simple, but this detail escaped me completely. Thank you! - jvleigh 12 years ago
Posted by:
GillySpy
14 years ago
This FAQ should help
http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=613&artlang=en
http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=613&artlang=en
Posted by:
londeaux
14 years ago
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.