/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


I need to learn MySQL :-( On Ticket save if Priority is HIGH, i need to send an email to an emailgroup

01/22/2020 216 views

I found examples here, but not exactly what im looking for.

I've got the email on ticket create and how to do it for a select word in the title, but cant figure out Priority …..

ThankS!!

0 Comments   [ + ] Show comments

Comments


All Answers

0

If you want the priory name you can join to the priority table to your SQL.

Here is a working example of a very basic query that is using a join to pull in data from other service desk tables.

Select HD_TICKET.ID as 'Ticket Number',
HD_TICKET.TITLE,
HD_IMPACT.NAME,
HD_PRIORITY.NAME,
HD_CATEGORY.NAME,
HD_STATUS.NAME
from HD_TICKET
join HD_IMPACT on HD_IMPACT.ID = HD_TICKET.HD_IMPACT_ID
join HD_PRIORITY on HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID
join HD_CATEGORY on HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID
join HD_STATUS on HD_STATUS.ID = HD_TICKET.HD_STATUS_ID

where HD_TICKET.ID = 1;


Ticket rules are very powerful and should be used with caution.

You should have a complete backup off loaded from your appliance before running any ticket rule and if possible you should test your ticket rule on a development SMA.

A simple mistake could corrupt your ticket DB.


We have a fee based professional services group that you can email for a quote on ticket rules, reports..   remoteconfig@quest.com

https://support.quest.com/kace-systems-management-appliance/kb/313481/kace-resources-training-and-professional-services




Answered 01/22/2020 by: KevinG
4th Degree Black Belt

0

It looks to me like you just need to understand the KACE database a bit better as that will also help. For example, if you know what priority ID that your high priority is, you can fire the ticket rule based on a single number, in a field, in the HD_TICKET table, rather than having to work out over complicated table joins ;o)

We also provide training and consultancy......just get in touch

Answered 01/22/2020 by: Hobbsy
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

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