Para gerar a lista de tutores de todos os cursos, pelo comando SQL, execute no terminal SQL o seguinte comando:
SELECT u.id, u.firstname,u.lastname,u.email,c.fullname AS course FROM mdl_role_assignments rs INNER JOIN mdl_user u ON u.id=rs.userid INNER JOIN mdl_context e ON rs.contextid=e.id INNER JOIN mdl_course c ON c.id=e.instanceid WHERE e.contextlevel=50 AND rs.roleid=3