One of my employee has left the org. i found few scheduled report were there in her account. so i have deleted the account from application. as per the application behavior if i have delete the technician all the scheduled report must move from exit employee account to mu account scheduled report. but here i am not able to see any scheduled report created by exit employee. please help me for deletion of scheduled reports created by exit employee. i can see the scheduled report using the below query. Thanks
select crd.report_name "Report name", ti.Schedule_time "Next
Scheduled Date", rst.mailid "Recipients", au.first_name "Technician Name
(owner)" from reportscheduletask rst
left join customreport_details crd on crd.reportid=rst.reportid
left join aaauser au on au.user_id=rst.ownerid
left join sduser sd on sd.userid=au.user_id
left join task_input ti on rst.instance_id=ti.instance_id
order by 1
Regards,
Subrata Pradhan
Mob- 9874562570