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_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
Query to find requests deleted by technician
Working on Builds 14500 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 ...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 ...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 find deleted survey (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Go to Reports >> New Query Report >> Run the below query to get the data SELECT err.message "System log message", err.errormodule "Module", err.suberrormodule "Sub Module", err.action "Action", ...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. ...