Total Course Logs

Total Course Logs

by Daniel Sims -
Number of replies: 1

Hi all, I use Course Logs very often for monthly reports and it would be handy to download the logs for every course at once with a "course name" column or such (filtered by the current month), save having to individually download every course log every month.

Is there any possible way to do this via configurable reports? I'm not new to SQL but I can't find any table or relationship pertaining to the course logs.

Diolch (Thank you)!

Average of ratings: -
In reply to Daniel Sims

Re: Total Course Logs

by Randy Thornton -
Picture of Documentation writers
There is no separate table for that. All logs are in the main table mdl_logstore_standard_log which has a column for course called courseid. All you need to do is filter on that column to limit it to specific courses. You will find several examples of how to use this in the Ad-hoc contributed reports page, eg https://docs.moodle.org/311/en/ad-hoc_contributed_reports#Total_activity_per_course.2C_per_unique_user_on_the_last_24h.
Average of ratings: Useful (2)