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





                    New to ADSelfService Plus?

                      • Related Articles

                      • Debug: Workaround for mail sending failure intermittently in Scheduled Reports

                        Root cause: For reports with inline images, the images will be generated as embedded image (data:image/xx). While sending mails, we will process this image using PreencodedMimeBodyPart. This internally triggers, "ImageDataContentHandler.writeTo()" ...
                      • Task related reports (MSSQL)

                        Tested in MSSQL build (14306) Sample Output and headers present in this report Goto reports -> New query report and executes the following SELECT taskdet.TASKID AS "Task ID", taskdet.MODULE AS "Module", taskprior.PRIORITYNAME AS "Priority", ...
                      • Scheduled Backup Failure

                        Sometimes the scheduled backup fails due to the below error in the logs, Error Message org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at ...
                      • Steps for deleting/modifying the reports created by other techs:

                        Steps for deleting/modifying the reports created by other techs: Connect to your database  To connect to your database please refer http://www.manageengine.com/products/support-center/faq-general.html Execute the below query which will give you the ...
                      • Auto Populate Scheduled Start Time and End Time in Change Request

                        We can now auto-populate the Scheduled Start Time and End Time in a change request using FAFR. Under Admin>Change Template>Field and Form Rules, you can use the below scrips Scheduled Start Time var x=$CS.getValue("SCHEDULEDSTARTTIME"); if ( x === ...