Request closed by and Resolved by from history

Request closed by and Resolved by from history

This report is used to find the closed by and resolved by technician from the history. In some cases the request may be assigned to some technician and it is closed by a different technician. This information is captured in the history. 


SELECT wo.WORKORDERID "Request ID",
       wo.title "Subject",
       ti.FIRST_NAME "Technician",
       aau.FIRST_NAME "Requester",

  (SELECT max(re.first_name) FROM workorderhistory woh1
   LEFT JOIN aaauser re ON woh1.operationownerid=re.user_id
   WHERE woh1.workorderid=wo.workorderid
     AND woh1.operation='RESOLVED') "Resolved by",

  (SELECT max(ce.first_name) FROM workorderhistory woh2
   LEFT JOIN aaauser ce ON woh2.operationownerid=ce.user_id
   WHERE woh2.workorderid=wo.workorderid
     AND woh2.operation='CLOSE') "Closeby" FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID
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
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 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?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • Related Articles

                    • Difference between resolved and Closed notification

                      The requester notifications are sent for two status: 'Resolved' and 'Closed' ​ Both 'Resolved' and 'Closed' are default completed statuses. When a technician provides a solution that he thinks will solve the issue, he/she can set the request to the ...

                    • Script to Disable Worklog Addition on Closed Request

                      Kindly use the below scripts under Admin -> Page Scripts to disable Worklog addition on Closed request. The below script hides the Save option while creating new worklog on closed request. Script: let params=new ...

                    • To reopen resolved ticket by requester reply.

                      * Navigate to Admin -> Self Self Service Portal settings    * Enable "Allow requesters to reopen their own requests" by choosing "Yes" (This option is interrelated to open resolved request on requester reply)    * Save changes and check the status. 

                    • Query to show who closed the request

                      PGSQL & MSSQL: select wo.workorderid "Request ID", aau.first_name "Request Closed By", cit.typename "Role", queuedefinition.queuename "Group" from WorkOrder wo LEFT JOIN WorkOrderHistory woh ON wo.WORKORDERID = woh.WORKORDERID LEFT JOIN ...

                    • How to close linked requests when a parent request is closed.

                      This post describes the use of a python script to close all the linked request when a parent request is closed using custom triggers. Use Case: We get tickets which are getting reported for the same issue but different end-users so that once we ...

                      Related Products