Request Problem association.

Request Problem association.

This Report is used to find the request, problem association.



SELECT wo.WORKORDERID "Request ID",
       sdo.NAME "Site",
       aau.FIRST_NAME "Requester",
       Longtodate(wo.CREATEDTIME) "Created Time",
       wo.TITLE "Subject",
       rrs.RESOLUTION "Resolution",
       std.STATUSNAME "Request Status",
       ti.FIRST_NAME "Technician",
       prob.PROBLEMID "Problem ID",
       prob.TITLE "Title",
       ownaaa.FIRST_NAME "Assigned to",
       Longtodate(prob.REPORTEDTIME) "Reported Date" FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID
LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID
LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID
LEFT JOIN ProblemToIncidentMapping pi ON wo.WORKORDERID=pi.WORKORDERID
LEFT JOIN Problem prob ON pi.PROBLEMID=prob.PROBLEMID
LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID
LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID
ORDER BY 1
 

Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report. 
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • Related Articles

                      • 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: Download the attached scripts. Goto Admin > Developer Space > ...

                      • 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 change association

                        This Report is used to find the request, problem and change association with the status of the association. To make any changes to a query, refer to the KB article below. ...

                      • 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") ...

                      • 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 ...

                        Related Products