Request deleted by technician

Request deleted by technician

This report is used to find the deleted request in the application. We can get the data from the Trash and system log viewer.  


SELECT err.message "System log message",
       err.errormodule "Module",
       err.suberrormodule "Sub Module",
       err.action "Action",
       err.type "Type",
       au.first_name "Performed by",
       longtodate(err.occurredtime) "Time of occurrence" FROM errorlog err
LEFT JOIN aaauser au ON err.ownerid=au.user_id
WHERE err.action LIKE '%Delete%'
  AND err.errormodule LIKE '%Request%'
  AND au.first_name IS NOT NULL
  AND occurredtime >= <from_thisweek>
  AND occurredtime <= <to_thisweek>

Trash

SELECT WORKORDERDELETEHISTORY.WORKORDERID "Request id",
       CI.CINAME "Requester",
       Workorder.TITLE "Subject" FROM WORKORDERDELETEHISTORY
LEFT JOIN Workorder ON WORKORDERDELETEHISTORY.WORKORDERID=WorkOrder.WORKORDERID
LEFT JOIN CI ON WorkOrder.REQUESTERID=CI.CIID
 

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

                      • Request violated by technician

                        This report used to find the technician who violated the request. If the request/incident already has a violation and is reassigned to another technician the new technician assumes the violation instead of the technician that the violation occurred.  ...

                      • Technician change from history

                        This report is used to find who changed the Technician and how many technician handled the request.  To make any changes to a query, refer to the KB article below. ...

                      • Technician

                        This report is used to find the Technician complete details.  SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...

                      • Update Task description with Request description.

                        Requirement: Copy the request description content to all the associated task description. Usecase: When a task is triggered from a request, it should contain the request description in the description of the task. This will enable task technician to ...

                      • Set Task Owner depending on the request field values

                        Requirement: Set Task Owner depending on the request field values. Usecase: When a task is triggered from a request, it should be assigned to a technician depending on the request field values. Steps to follow: Goto Admin > Task Custom Functions > ...

                        Related Products