I have found "Users"/"Accounts"/"Browse List of Users", but (as administrator) how can I find a user, then list all the classes for which he or she is registered?
Thanks,
Neal
http://NealWalters.com - Does that beard really make him look like the presidents?
Neil
If you can run a query run this query :
SELECT usr.firstname, usr.lastname, usr.email, c.fullname
FROM mdl_course c
INNER JOIN mdl_context cx ON c.id = cx.instanceid
AND cx.contextlevel = '50'
INNER JOIN mdl_role_assignments ra ON cx.id = ra.contextid
INNER JOIN mdl_role r ON ra.roleid = r.id
INNER JOIN mdl_user usr ON ra.userid = usr.id
WHERE r.name = 'Student'
ORDER BY usr.firstname, c.fullname
Best regards
