Survey
Query to show all request along with a column to show survey completed or not. (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306) Please go to Reports > New Query Reports and execute the below query (MS-SQL & PGSQL): SELECT wo.WORKORDERID AS "Request ID", max(wo.TITLE) AS "Request Title", max(aau.FIRST_NAME) AS "Requester", ...
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", ...
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 ...
Query to show the survey sent and received count( PGSQL & MSSQL )
Tested in Build PGSQL (14300) or MSSQL (14306) Go To Reports- New Query Report and execute this query. select adef.org_name "Account",count(srm.responseid) as "Total Survey Sent",count( CASE WHEN srm.responsetype!=3 then 1 ELSE NULL END) as "Total ...
Query to show Count of survey sent and received per account (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) SELECT adef.org_name "Account",COUNT(srm.surveyid) "Total surveys sent", COUNT (sra.responseid) "Total surveys received" FROM SurveyResponseRequestMapping srrm INNER JOIN Survey_Response_Main srm ON ...