How to restrict technician from being assigned with new tickets when he has 10 open tickets in his queue already
Usecase:
If a technician has 10 open tickets assigned to him already, the new upcoming requests should not be assigned to him. New tickets can be assigned only on completing the pending tickets. In Business Rules, under execute script action we can invoke a Python script to negate this operation.
Requirements:
1. Python Installation Steps: https://support.servicedeskplus.com/portal/kb/articles/setting-up-the-application-server-to-run-python-scripts
2. functions.py: This package consists of all the functions that are used to handle the standard requirements of the customer. Most repeated requirements are written as separate functions. Depending on our use case, we can include these functions in our script.
3. configuration.json: This file maintains the configuration details of the installed server.
Execution Steps:
1. Extract the ZIP file under ..\ManageEngine\Servicedesk\integration\custom_scripts - folder.
2. Edit the configuration.json and update the values.
3. For BR Scripts: Go to Admin > Business Rules > give a rule name> Action: Execute script > "py negate_technician_count.py $COMPLETE_V3_JSON_FILE" and set the criteria as "Status=Open"
Business Rule:
New to ADSelfService Plus?
Related Articles
Query to show tickets first assigned today irrespective of created date
MSSQL: SELECT wo.WORKORDERID "Request ID", max(aau.FIRST_NAME) "Requester", max(dpt.DEPTNAME) "Department", max(wo.TITLE) "Subject", max(qd.QUEUENAME)"Group", max(ti.FIRST_NAME) "Technician", max(std.STATUSNAME) "Request Status", ...Query to show the number of days, the tickets are open_PGSQL
select wo.WORKORDERID"Request ID", qd.QUEUENAME "Group", aau.FIRST_NAME "Requester", wo.TITLE "Subject", ti.FIRST_NAME "Technician", sdo.NAME "Site", LONGTODATE(wo.CREATEDTIME) "Created Time", round(extract(epoch from(now()::TIMESTAMP - ...Query to show first assigned and re-assigned ticket irrespective of the created date ( MSSQL)
Tested in build MSSQL (14306) MSSQL: SELECT wo.WORKORDERID "Request ID", max(aau.FIRST_NAME) "Requester", max(dpt.DEPTNAME) "Department", max(wo.TITLE) "Subject", max(qd.QUEUENAME)"Group", max(ti.FIRST_NAME) "Technician", max(std.STATUSNAME) "Request ...Request violated by technician
This report used to find the technician who violated the request. If the request/incident already has a violation and is reassigned to another technician the new technician assumes the violation instead of the technician that the violation occurred. ...Query to show tickets older than 30 days ( MSSQL )
Tested in build MSSQL (14306) MSSQL: SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",std.STATUSNAME "Request Status",wo.TITLE "Subject",aau.FIRST_NAME AS "Requester Name", pd.PRIORITYNAME as "Priority", adef.ORG_NAME as "Account", ...