Total Course Logs

Total Course Logs

di Daniel Sims -
Numero di risposte: 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)!

Media dei voti: -
In riposta a Daniel Sims

Re: Total Course Logs

di Randy Thornton -
Immagine 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.