Automatic Problem Creation for Request Clustering

Automatic Problem Creation for Request Clustering

Requirement:
Automatically create a problem when there are threshold number of requests created with the same category/subcategory/item within a specified time frame.

Steps to configure:
  1. Download the attached scripts.  
  2. Goto Admin > Developer Space > Global Function > Copy & Paste the attached GF_4 - Configuration.txt and save it with a name.
  3. Goto Admin > Developer Space > Request Custom Function > Copy & paste addProblemAndAssociateReq.txt and save it with a name.
    • Update the global function count according to your instance.  In my case it's global_function_4().  
    • Also, update the timezone and the number of minimum requests required to create a problem.  In my case timezone is set as "Asia/Calcutta" and minimum number of requests is set as 10.  Both can be modified to suit your preference.
  4. Configure the created custom function in a trigger to get executed every time a request is created.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Auto-create problem request based on certain criteria.

                        This is a sample script that triggers the creation of a Problem Request in ServiceDesk Plus using the Problem API.  Use Case:  ​ All incident requests with Priority = High will create a problem ticket with the request's default field values. ...
                      • Request Problem association.

                        This Report is used to find the request, problem association. To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT wo.WORKORDERID ...
                      • Problem and Associated incidents with Request id

                        MSSQL SELECT "prob"."PROBLEMID" AS "Problem ID", max("prob"."TITLE") AS "Title", longtodate(max("prob"."REPORTEDTIME")) AS "Reported Date", max("prob"."DUEBYTIME") AS "DueBy Date", max("orgaaa"."FIRST_NAME") AS "Reported by", max("probf"."UDF_CHAR1") ...
                      • ADMP Integration - How to automate AD user creation

                        This post described the use of a python script to automate AD user creation from request. This script can be configured under Request custom triggers and you will find more information about this here. Integrating ServiceDesk Plus with ADManager Plus ...
                      • Problem Notes

                        SELECT prob.PROBLEMID "Problem ID", prob.TITLE "Title", ownaaa.FIRST_NAME "Technician", longtodate(prob.REPORTEDTIME) "Reported Date", sdno.description "Notes" FROM Problem prob LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID LEFT JOIN AaaUser ...