I am using moodle for 6 centers. So in my mdl_user table, I have used the field "city" to record the centers where my students are from.
I also added a new user profile field "institution" to record where my teachers are from.
I need to have a sql to extract list of activities/usage for all courses breakdown by each center for the whole 2015.
Is there anyone who can help me on this?
p/s: I am using the latest moodle at the moment. I have switched on both "Legacy" and "standard" logging in my log store plugins.
Thank you
Regards,
Jack