|
|
Línea 1: |
Línea 1: |
− | Para sacar dichos listados:
| |
| | | |
− | root@bbdd-lab:~# mysql -u root -p moodle_lab -e "
| |
− | SELECT mdl_user.id,
| |
− | mdl_user.lastname,
| |
− | mdl_user.firstname,
| |
− | mdl_user.idnumber
| |
− | FROM mdl_course
| |
− | INNER JOIN mdl_context
| |
− | ON mdl_context.instanceid = mdl_course.id
| |
− | INNER JOIN mdl_role_assignments
| |
− | ON mdl_context.id = mdl_role_assignments.contextid
| |
− | INNER JOIN mdl_role
| |
− | ON mdl_role.id = mdl_role_assignments.roleid
| |
− | INNER JOIN mdl_user
| |
− | ON mdl_user.id = mdl_role_assignments.userid
| |
− | WHERE mdl_role.id = 5 and mdl_course.id=81
| |
− | INTO OUTFILE '/tmp/Lista-RDOR.txt' FIELDS TERMINATED BY ',';"
| |
− |
| |
− |
| |
− | Sustituyendo mdl_course.id=81 por el ID correspondiente en cada caso.
| |