Scheduled Reports

Scheduled Reports

This report is used to get the complete list of all the scheduled reports with the owner name configured in the application. 

SELECT CustomReport_Details.REPORT_NAME "Report Name",
       AaaUser.FIRST_NAME "Owner" FROM ReportScheduleTask
LEFT JOIN CustomReport_Details ON ReportScheduleTask.REPORTID=CustomReport_Details.REPORTID
LEFT JOIN SDUser ON ReportScheduleTask.OWNERID=SDUser.USERID
LEFT JOIN AaaUser ON SDUser.USERID=AaaUser.USER_ID