| 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

Pearson
Always Learning
www.pearsonschoolsystems.com 
Tel: 866-434-6276
Email: psstechsupp@pearson.com