| Reporting on information > Running a report > Monitoring reports using SQL > Monitoring built-in reports

Monitoring built-in reports

A built-in report does not appear in the task table [>>]. Instead it appears in the CSL_SMS_REPORT_QUEUE table. The administrator can monitor this type of report by using a SQL statement.

To view a list of built-in reports that are currently running:

Use the following SQL statement:

SELECT CSL_SMS_REPORT.NAME, CSL_SMS_REPORT_STATUS.REPORT_STATUS_DESCRIPTION STATUS, CSL_SMS_REPORT_QUEUE.* FROM CSL_SMS_REPORT_QUEUE, CSL_SMS_REPORT, CSL_SMS_REPORT_STATUS

WHERE CSL_SMS_REPORT_QUEUE.ID_SMS_REPORT = CSL_SMS_REPORT.ID_SMS_REPORT

AND CSL_SMS_REPORT_QUEUE.ID_SMS_REPORT_STATUS = CSL_SMS_REPORT_STATUS.ID_SMS_REPORT_STATUS

www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com