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. 




        New to ADManager Plus?

          New to ADSelfService Plus?

          Start your free trial

            • Related Articles

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

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

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

            • Fix: Attachments with mismatched content-type cannot be added through mail

              Issue: Attachments with mismatched content-type are stripped when sent through mail. The sender of the mail as well the technicians configured under "Application error" notification rule will be notified on this (Refer here for more details). But in ...

              Related Products