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
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", ...AD Scheduled Import : Option to verify AD attribute mapped to the Fields in SDP MSP
Option to verify AD attribute mapped to the Fields in SDP MSP in scheduled AD import. Once the setting is configured while doing a manual import, the same configuration will be mapped for scheduled AD import as well. Kindly use the below query to ...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 ...Known issue in Reports throwing error in UI
Issue - Reports thrown error in UI Trace in Logs. [12:23:37:156]|[02-13-2023]|[SYSERR]|[INFO]|[27512]: Thread Thread[Thread-129,5,main] exited unexpectedly.java.lang.NoClassDefFoundError: Could not initialize class ...Scheduled Backup failure due to permission issue in pgsql folder
Error Traces: [com.adventnet.db.adapter.BackupRestoreUtil]|[WARNING]|[250]: pg_basebackup: could not get write-ahead log end position from server: ERROR: could not open file "./pg_hba.conf_3may23.bkp": Permission denied| ...