/build/static/layout/Breadcrumb_cap_w.png

Run ticket rule once per ticket

I have several simple ticket rules that were created with the wizard to populate certain fields. All of these rules work correctly, however I would like for them to only run once opun ticket creation. Some of these field may need to be changed later, and I don't want the ticket rules changing them back during a scheduled run or on ticket save. Is there a way to make a ticket rule only run once per ticket. It would be nice to have an option for a rule to run "On Ticket Creation"

Please explain in dumb terms because I am not very experienced with SQL


0 Comments   [ + ] Show comments

Answers (2)

Posted by: chucksteel 10 years ago
Red Belt
0

I normally set the default value of the fields to something like "Set on Save" and then have the rule check to see if the field is set to that default value. That way once the value is changed the rule won't get triggered again.

Posted by: jbunnell 10 years ago
Yellow Belt
0

I found the solution in another thread similar to this one. You can add this to the scripting to check whether the ticket is being created. Set this to run "On Ticket Save" and it will only be able to run on ticket creation.

------------------------------------------------------------------------------------------------------
If you only want a rule to be effective the moment a ticket is created then you add in a join to HD_TICKET_CHANGE and look for "Ticket Created" like this:

.
.
.
from (HD_TICKET, HD_PRIORITY, HD_STATUS, HD_IMPACT, HD_CATEGORY)
JOIN HD_TICKET_CHANGE C ON C.HD_TICKET_ID=HD_TICKET.ID and C.ID=<CHANGE_ID> and C.DESCRIPTION LIKE 'Ticket Created%'
.
.
.

------------------------------------------------------------------------------------------------------


Comments:
  • There is an old KACE FAQ on doing this but it has given me nothing but trouble, and whenever I update a ticket it still reads the TICKET CREATED and updates the ticket. - Wildwolfay 10 years ago

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