General help

I am not an expert in all the ways to connect to a database. If you have ssh access to your server, one can run MySQL queries from a command line. I tend to prefer utilities like phpMyAdmin, but power database folks would probably say the command line is more powerful (and I agree). Once I get my query working, I then use the "Configurable Reports" plugins to help me organize and manage my queries. This seems to work well. However, I am the instructor, the Moodle admin, the server admin, and database admin rolled into one person, so I have complete rights (to do damage, too).

You can use the various completion api to get activity completion status: for example:

core_completion core_completion_get_activities_completion_status 2.9 Return the activities completion status for a user in a course. No Yes moodle_mobile_app
core_completion core_completion_get_course_completion_status 2.9 Returns course completion status. No Yes moodle_mobile_app
core_completion core_completion_override_activity_completion_status 3.4 Update completion status for a user in an activity by overriding it. Yes Yes


There are no APIs yet that I know of that directly access the logs, however. Perhaps someone else knows the details of that. In any case, to get just activity completion, you don't need the logs at all, that data is stored in the course modules completion table.