Survey Query Report using percentage values for customer satisfaction - MS SQL db, ManageEngine 10.5 (build 10513).

Survey Query Report using percentage values for customer satisfaction - MS SQL db, ManageEngine 10.5 (build 10513).

Hi,

Could you please provide a query to run a survey report based on the % of satisfaction level for MS SQL, ManageEngine 10.5 (build 10513)?

Query below stopped working after ManageEngine upgrade:

SELECT MAX(wo.TITLE) "Request Title",MAX(aau.FIRST_NAME) "Requester", DATE_FORMAT(FROM_UNIXTIME(MAX(wo.CREATEDTIME)/1000),'%d-%m-%Y %k:%i') "Request Created Time",MAX(ti.FIRST_NAME) "Technician",DATE_FORMAT(FROM_UNIXTIME(MAX(wo.COMPLETEDTIME)/1000),'%d-%m-%Y %k:%i') "Completed Time",sum(sadt.RATING) "Rating" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID LEFT JOIN WorkOrder wo ON spr.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID group by wo.WORKORDERID


Thanks in advance!
Kind regards,
Dmitry

                  New to ADSelfService Plus?