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

                    • Adding attachment to Resolution using API

                      PURPOSE: To add an attachment to the resolution via API. STEPS: 1) Upload the attachment file and obtain the attachment ID: URL: <domain_url>/api/v3/requests/upload Method: POST Payload: files ( input_data = <file_content> ) Response: 2) Add the ...

                    • Script to Auto close a request by adding a resolution using deluge script

                      Please note the script provided will work only from builds 10600 and above 1: Download the attached script and extract it. 2: Go to Admin > Request Custom Functions > Global function > New > Paste the content from the attachment 1.configuration.txt ...

                    • Query to show Last added worklog of a ticket ( MSSQL )

                      Tested in build MSSQL (14306) MSSQL: SELECT wo.WORKORDERID AS "Ticket Number", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", aau.FIRST_NAME AS "Requester", Wo.title "Subject", ...

                    • Script to Update date/time additional field inside request when note is added.

                      (Applicable for builds 14300 & above) Please follow the below mentioned steps to configure: First Download and extract the attached zip file containing the scripts & attachments (screenshots) 1.Goto Admin > Developer space --> Custom Functions > ...

                    • Minimum Character check for a resolution

                      Requirement: Resolution content is mandatory when a request is being resolved. But frequently, when closing a request, technicians write incorrect or meaningless text in the resolution content. So, we will need to evaluate resolution content's ...

                      Related Products