非標準プラグインのAd-hoc database queries※1をインストールした上でSQL「User Course Completion」※2を使用した場合、各コースでのユーザの完了日時をCSVファイル形式で取得可能です。必要に応じてSQL「User Course Completion」の記述をご変更ください。
[※1 Reports: Ad-hoc database queries]
https://moodle.org/plugins/report_customsql
[※2 User Course Completion - ad-hoc contributed reports - MoodleDocs]
https://docs.moodle.org/39/en/ad-hoc_contributed_reports#User_Course_Completion
> 各コースでのユーザの完了日時ではなく、進捗率というのも、SQLデータを書き換えれば取得可能なのでしょうか？
可能だと思います。
以下のようなAd-hoc database queries用SQL文ではいかがでしょうか。
SELECT u.username AS 'Username', u.lastname AS 'Lastname', u.firstname AS 'Firstname', u.email AS 'Email', c.fullname AS 'Course Fullname', c.shortname AS 'Course Shortname',
(SELECT COUNT(*)
FROM prefix_course_modules cm
WHERE cm.course=en.courseid AND cm.completion = 2) AS 'Course Modules',
(SELECT COUNT(*)
FROM prefix_course_modules_completion cc
JOIN prefix_course_modules cm ON cm.id = cc.coursemoduleid
WHERE cm.course=en.courseid AND cc.userid=ue.userid AND cc.completionstate = 1) AS 'Modules Completed',
ROUND((
(SELECT COUNT(*)
FROM prefix_course_modules_completion cc
JOIN prefix_course_modules cm ON cm.id = cc.coursemoduleid
WHERE cm.course=en.courseid AND cc.userid=ue.userid AND cc.completionstate = 1) /
(SELECT COUNT(*)
FROM prefix_course_modules cm
WHERE cm.course=en.courseid AND cm.completion = 2) * 100),2) AS 'Progress %'
FROM prefix_user_enrolments ue
JOIN prefix_enrol en ON en.id = ue.enrolid
JOIN prefix_user u ON u.id=ue.userid
JOIN prefix_course c ON c.id=en.courseid
