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()" ...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 ...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", ...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 === ...