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",
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.suberrormodule LIKE '%Survey%'
AND au.first_name IS NOT NULL
que
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 ...Query to find out who created Accounts (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) Execute the below queries under Reports->New Query Report. select org_id, org_name from accountdefinition ad where ad.org_name in('Requester Name', 'Palanivel Palras','Muhammad Nadeem Khan') Note down ...Qyery to bring Survey reports based on technicians , tickets, satisfactory level (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) 1. Login to SDP MSP as administrator 2. Execute this from SDP MSP application -> Reports -> New Query report select srrm.workorderid AS "Ticket Number",aau.FIRST_NAME as "Requester Name",srm.RESULT as ...How to calculate satisfactory level for Survey
We are considering the rating value (Score) in the calculation of the survey Example : Suppose the Survey has 7 Questions with maximum of 10 Radio type points and each points carry above mentioned score. If customer clicks 9 for all 7 questions (that ...Query to show Average response time for Category (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) PGSQL: SELECT accountdefinition.org_name "Account",cd.categoryname "Category", TO_CHAR(((avg(wo.respondedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Response Time" FROM ...