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.  

To make any changes to a query, refer to the KB article below.

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_today>
  AND occurredtime <= <to_today>
Available Date Templates

Today - <from_today> - <to_today>
This week - <from_thisweek> - <to_thisweek>
Last week - <from_lastweek> - <to_lastweek>
This month - <from_thismonth> - <to_thismonth>
Last month - <from_lastmonth> - <to_lastmonth>
This quarter - <from_thisquarter> - <to_thisquarter>
Last quarter - <from_lastquarter> - <to_lastquarter>
Yesterday - <from_yesterday> - <to_yesterday>
This year - <from_thisyear> - <to_thisyear>
Last year - <from_lastyear> - <to_lastyear>

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
 
          • Related Articles

          • Can we restore a deleted technician as it appears under deleted users?

            Once a technician user account is deleted, the same user account cannot be added back. When a technician is deleted, we do not delete all the traces of the user. For historic purposes, the user will be available in certain records.  create a new user ...
          • Query to track technician activity on tickets

            Use case: This query will help you find what are all activities that the technicians have done on requests other than the assigned ones SELECT au.first_name "Technician" ,wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wo.TITLE ...
          • Query to know the technician changes in a ticket

            This will show the output only if the technician is assigned/updated in a ticket 1. Login to SDP MSP as administrator 2. Execute this from SDP MSP application -> Reports -> New Query report SELECT wo.WORKORDERID AS "Request ID",  wo.TITLE AS ...
          • Request missing

            Use case: In some cases, requests are missing. We would get the ID number from acknowledgement notification but we cannot find that in the tickets. In such cases, please follow below steps to find out the details. 1. Make sure to check the Request ...
          • Query to show technician hop count

            MSSQL: SELECT wo.WORKORDERID "Request ID", LONGTODATE(wo.CREATEDTIME) AS "Created Time", qd.QUEUENAME "Current Group",aau.FIRST_NAME AS "Requester",  ti.FIRST_NAME "Technician", ad.ORG_NAME AS "Account", ti1.FIRST_NAME "From technician", ...