Resolution added by

Resolution added by

This report is used to find the resolution added by technician.


SELECT wo.WORKORDERID "Request ID",
       wo.title "Subject",
       ti.FIRST_NAME "Technician",
       aau.FIRST_NAME "Requester",
       rrs.RESOLUTION "Resolution",
       aar.first_name "Resolution added by" FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID
LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID
LEFT JOIN aaauser aar ON rrr.technicianid=aar.user_id
WHERE (wo.ISPARENT='1')
  AND wo.CREATEDTIME >= <from_lastmonth>
  AND wo.CREATEDTIME <= <to_lastmonth>

 
Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report. 


          • Related Articles

          • Average Resolution Time based on Technicians

            This report is used for the customers that Technicians provide a consistent level of support. It can be confusing and frustrating for customers to have some Technicians resolve quickly, while other Technicians takes days to resolve the issues and ...
          • Average Resolution Time based on Group

            This report is used for the customers that support groups provide a consistent level of support. It can be confusing and frustrating for customers to have some support groups resolve quickly, while other support groups takes days to resolve the ...
          • Last work log added

            This report is used to get the latest worklog added in the request. 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 ...
          • Update Resolution from one SDP instance to another - Deluge

            Use Case: There are scenarios where two ServiceDesk plus instances are used in an organization for different departments and requests created in one instance is duplicated in another.  Similarily when a resolution is updated in one the same has to be ...
          • Jar-Fix for solution search under Resolution tab in Request Module (SD-77150)

            SD-77150 is also found in Support Ticket #5230977. This jar is applicable for products whose product version is below 10017. Follow these steps Download the Jar file from here. Place it under <Product Home>\fixes\ Restart the application.