IFNULL(OWNER.USER_NAME,'Unassigned') OWNER_USER, - $owner_user

OWNER.EMAIL AS OWNER_EMAIL, - $owner_email

OWNER.FULL_NAME AS OWNER_FNAME, - $owner_fname OWNER.USER_NAME AS OWNER_UNAME, - $owner_uname IF(UPDATER.FULL_NAME='',UPDATER.USER_NAME,UPDATER.FULL_NAME) AS UPDATER_CONDITIONAL, - $updater_conditional UPDATER.EMAIL AS UPDATER_EMAIL, - $updater_email UPDATER.FULL_NAME AS UPDATER_FNAME, - $updater_fname UPDATER.USER_NAME AS UPDATER_UNAME, - $updater_uname ORDER BY H.ID DESC SEPARATOR ' ') HISTORY, - $history H.DESCRIPTION,' ',H.COMMENT,' Please see your ticket at ' ,H.HD_TICKET_ID,' ') GROUP_CONCAT(CONCAT('- Change by ', UPDATER.EMAIL,' at ',H.TIMESTAMP,' - ', (Highlighted in red in the below rule)īelow is a summary of the completed rule:ĭATE_FORMAT(HD_TICKET.CREATED,'%b %d %Y %I:%i:%s %p') AS CREATED, - $createdĭATE_FORMAT(HD_TICKET.MODIFIED,'%b %d %Y %I:%i:%s %p') AS MODIFIED, - $modified Add the email address of the user or group by locating the portion of the query, adding the correct address(s).(Highlighted in purple in the below rule) Modify the “ portion of the query to include the local address of your KACE appliance.But in 5.0 and newer we can use variables so use this NEW TICKET: $title So choose static text for older versions. Note that the subject of an email is not customizable before version 5. (Watch out for quotes when you copy/paste). Use the query below that is customized to meet our needs.Disable the rule so that we can perform some testing by unchecking “enabled”.We are going to modify the completed rule. The information below describes how to notify a user or group via Custom Ticket Rule. When a ticket is created you can notify any user or group by email via two different methods. NOTE: Please review KB Article Precautions for Creating Ticket Rules before attempting to create this ticket rule. See the attached word document for K1000 server version 6.3 and below. NOTICE: The information below is for K1000 server version 6.4 and above ONLY. QUEST KACE SHALL NOT BE HELD LIABLE FOR DAMAGE OR DOWN TIME RESULTING FROM USE OF THIS OR ANY CODE PRESENTED FOR PURPOSES OF TROUBLESHOOTING OR DEMONSTRATION CLIENT CONFIRMS THE NEED FOR TESTING AND ACCEPTS ALL RESPONSIBILITY FOR USE AND MISUSE OF CODE. Storage Performance and Utilization ManagementĬODE WRITTEN BY QUEST KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY AND NOT SUPPORTED BY KACE TECHNICAL SUPPORT.Information Archiving & Storage Management.Hybrid Active Directory Security and Governance.Starling Identity Analytics & Risk Intelligence.One Identity Safeguard for Privileged Passwords.

Ancestral quest help email