/build/static/layout/Breadcrumb_cap_w.png

K1000 rule: date alarm

As kace still doesnt have and SLA alarm in any way, i have created a very simple rule for a pending date. when somebody of support wants to attend one ticket in a particular date, they select the date in a date custom field and when it is that date, then they receive and email remembering them to solve that ticket.

->Select SQL

select HD_TICKET.ID AS ID, HD_TICKET.TITLE AS TITULO, 
  HD_TICKET.CUSTOM_FIELD_VALUE1 AS DataDePendencia,
           A.FULL_NAME AS ATENDENTE,
           A.EMAIL AS EMAIL_ATENDENTE
       
from HD_TICKET
INNER JOIN USER A ON (A.ID = HD_TICKET.OWNER_ID)

WHERE  HD_TICKET.CUSTOM_FIELD_VALUE1 = CURDATE()

GROUP BY HD_TICKET.TITLE

->Active the email checkbox and write the notification
Assunto: Data de Pendencia TICKET:[$id] $titulo
Coluna contendo endereços de e-mail: EMAIL_ATENDENTE
Mensagem: XXXXXXX

->Actualized SQL

update HD_TICKET
set HD_TICKET.CUSTOM_FIELD_VALUE1 = '0000-00-00'


where HD_TICKET.ID in (<TICKET_IDS>) 

Posted 9 years ago 2425 views

Comments

  • That's a nice touch to set the date so the alert only gets sent once. Do you also have the rule set to run just once a day? - chucksteel 9 years ago
    • ohh yes, i forgot it. actually i have set the frequency in 15 minutes but as the couter become to 0 everytime it sends the email then it is sent just once.
      i tried to put it also with time, but i dont know why the time becames to 0 when you save the ticket, so it wasnt working at all. - Paloma 9 years ago
This post is locked
 
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