Kace 1000 is not emailing reports (SMTP email test confirmed working)
All,
Starting in a previous version of Kace firmware, Kace stopped emailing reports. Reports can be run and viewed within Kace, but the emails never send.
All of our Service Desk emails go out. Testing SMTP using Support Tools sends emails fine. Reports are the only emails not going. Logs show nothing (blank).
Any assistance would be helpful!
2 Comments
[ + ] Show comments
Answers (4)
Answer Summary:
Please log in to answer
Posted by:
SMal.tmcc
9 years ago
compare one of your reports to this one. I put the CC Recipients in by hand (did not use the "Select user to add" box). make sure you have a comma in between, no spaces.
Comments:
-
I'm only using 1 email address. Otherwise, looks the same. - shipupride 9 years ago
Posted by:
SMal.tmcc
9 years ago
Posted by:
shipupride
9 years ago
Top Answer
Log:
[2015-09-24 11:24:34 -0400] Executing query: SELECT HD_TICKET.CREATED, HD_TICKET.ID, S.FULL_NAME AS SUBMITTER_NAME, HD_TICKET.CUSTOM_FIELD_VALUE2, HD_PRIORITY.NAME AS PRIORITY, O.FULL_NAME AS OWNER_NAME, HD_STATUS.NAME AS STATUS_NAME, HD_TICKET.MODIFIED, HD_TICKET.TITLE, HD_TICKET.ID as TOPIC_ID FROM HD_TICKET LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 2) AND ((HD_STATUS.NAME != 'Closed') AND ((HD_TICKET.CUSTOM_FIELD_VALUE2 = 'Utility Billing') OR (S.USER_NAME = 'lstrusowski') OR (S.USER_NAME = 'cduvall') OR (S.USER_NAME = 'sbrady') OR (S.USER_NAME = 'mrangel-wanros') OR (S.USER_NAME = 'mvispi') OR (S.USER_NAME = 'ddaniels') OR (S.USER_NAME = 'ljones'))) ORDER BY ID
[2015-09-24 11:24:34 -0400] Query finished.
[2015-09-24 11:24:34 -0400] Begin Excel result set processing.
[2015-09-24 11:24:35 -0400] End Excel result set processing.
[2015-09-24 11:24:35 -0400] KSmartyServer[60118]: Run time: 1 second ago
[2015-09-24 11:24:35 -0400] KSmartyServer[60118]: Peak memory usage: 42,205,184/256M bytes
[2015-09-24 11:24:35 -0400] KSmartyServer[60118]: Output: /tmp/reports/1036749993, 8,838 bytes
[2015-09-24 11:24:35 -0400] KSmartyServer[60117]: Command exit status is 0
[2015-09-24 11:24:35 -0400] KSmartyServer[60117]: Report run successfully
[2015-09-24 11:24:35 -0400] KSmartyServer[1081]: Cleaning up child process 60117 for 1036749993
Comments:
-
everything looks right, so I say open a ticket with kace to see if something internal is at fault and while you are waiting for that check to see if some mail system/server/appliance it is flowing thru is filtering or blocking messages from reporter@kace.newark.de.us - SMal.tmcc 9 years ago
[2015-09-24 11:24:34 -0400] Query finished.
[2015-09-24 11:24:34 -0400] Begin Excel result set processing.
[2015-09-24 11:24:35 -0400] End Excel result set processing.
[2015-09-24 11:24:35 -0400] KSmartyServer[60118]: Run time: 1 second ago
[2015-09-24 11:24:35 -0400] KSmartyServer[60118]: Peak memory usage: 42,205,184/256M bytes
[2015-09-24 11:24:35 -0400] KSmartyServer[60118]: Output: /tmp/reports/1036749993, 8,838 bytes
[2015-09-24 11:24:35 -0400] KSmartyServer[60117]: Command exit status is 0
[2015-09-24 11:24:35 -0400] KSmartyServer[60117]: Report run successfully
[2015-09-24 11:24:35 -0400] KSmartyServer[1081]: Cleaning up child process 60117 for 1036749993 - shipupride 9 years ago