Surveys not answered

Surveys not answered


Execute the below query under Report tab--> New Query Report

select nw.workorderid"RequestID",nof.notificationtitle"Survey Message",nof.notificationtype'Type',au.first_name"Sent To" from notification nof
left join notify_workorder nw on nw.notificationid=nof.notificationid
left join aaauser au on au.user_id=nof.recipientid
where notificationtitle like '%improve%survey%'
and nw.WORKORDERID not in (Select WORKORDERID from SurveyPerRequest)

Krishna Bharat

ServiceDesk Plus - MSP Support team

                New to ADSelfService Plus?