Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Ticket Rules enable you to run queries on Service Desk tickets and perform actions on the list of tickets returned.
Cause
Ticket rules can damage the data in your SMA appliance. Poorly written queries can be inefficient enough to cause significant performance degradation. Also update statements can alter the data of your tickets and other fields in the database.
Resolution
The following precautions should be taken when creating ticket rules:
Backup your data on all test and production machines. See About appliance backups at https://support.quest.com/technical-documents/doc963648 in the Administrator Guide.
Do your ticket rule development in a safe area. A safe area might be:
A separate, test helpdesk queue with representative sample of data.
A test organization (only valid on a Orgs Enabled Appliance).
A fully backed up SMA appliance that is not used for production purposes.
A second SMA appliance such as a virtual appliance.
Consider having KACE Professional Services do the work or review your work. This is a fee-based service.
Test query results before proceeding with any kind of update. Use MySQL Workbench or another third party tool to test.
Never click the "Run Now" button on a ticket rule that has a frequency of "On ticket save".
Always backup your database before and after design, testing and implementation.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
KACE Systems Management Appliance
14.0, 13.2, 13.1
KACE as a Service
14.0, 13.2, 13.1
Topic(s):
Best Practices, How To
Article History:
Created on: 8/17/2013 Last Update on: 6/5/2024
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.