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 ADSelfService Plus?

                      • 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", ...
                      • How to Auto Share Request Upon Creation to All/Selected Technicians

                        NOTE:  This script is supported only for builds below 11.3 This post describes the use of a python script to share requests to technicians specified in a list variable in the script, which can be generated from an SQL query. This script can be ...
                      • Notify previous technician, when a request is reassigned

                        UseCase: We get default notification when a request is assigned, but there is no default notification when a request is reassigned to a different technician. Requirement: Assume a request is assigned to Technician A, and later reassigned to ...