### Comprehensive Report

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.
Comprehensive Report

My site consists of 13 courses and apporximately 500 users.  Most users are enrolled in all courses.  Is there a way to obtain a report that shows all courses, and all users indicating their quiz score?  Currently I have to download a grader report from each individual course.

Re: Comprehensive Report

Run this query.

SELECT c.shortname AS shortname, CONCAT(mu.firstname, ' ', mu.lastname) AS fullname, gg.finalgrade AS finalgrade