Moodle en Español: Reportes generales de Moodle

Hola Claudio, te comento que yo no he encontrado un plugin que revise tod el estatus de un sólo usuario pero vi a un administrador si no mal recuerdo de Panamá que había realizado un query donde revisaba todo lo realizado por usuario X pero lo perdí de vista, esto hace unas tres semana o más.

Lo que yo uso son lugins individuales donde arrojan ciertos datos que te podrían ser útiles en el desarrollo de tus reportes, te dejo algunos de los que uso y me han servido, te aconsejo igual que éches un vistazo a los plugins para administradores.

https://moodle.org/plugins/report_overviewstats

https://moodle.org/plugins/local_analytics

https://moodle.org/plugins/block_use_stats

https://moodle.org/plugins/block_analytics_graphs

Promedio de calificaciones: -

Enlace permanente | Mostrar mensaje anterior | Responder

Lo encontré, te dejo el enlace al hilo.

https://moodle.org/mod/forum/discuss.php?d=348975#p1408275

Promedio de calificaciones: -

Enlace permanente | Mostrar mensaje anterior | Responder

Muchismas gracias Jose Luis por tu aporte lo investigo y les comento , saludos Claudio

Promedio de calificaciones: -

Enlace permanente | Mostrar mensaje anterior | Responder

Hola Claudio yo talvez te pueda ayudar con una de tus inquietudes (1)

ESta consulta la creo Cristian Blanquer : https://moodle.org/mod/forum/discuss.php?d=346950&parent=1401289

Nombres de los profesores

select

C.fullname,

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 01 ) as 'Enero',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 02 ) as 'Febrero',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 03 ) as 'Marzo',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 04 ) as 'Abril',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 05 ) as 'Mayo',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 06 ) as 'Junio',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 07 ) as 'Julio',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 08 ) as 'Agosto',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 09 ) as 'Septiembre',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 10 ) as 'Octubre',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 11 ) as 'Noviembre',

(select GROUP_CONCAT(CONCAT(U.firstname, ' ', U.lastname) SEPARATOR ', ') FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 12 ) as 'Diciembre'

FROM mdl_course C

WHERE fullname='NOMBRE_CURSO'

or fullname='NOMBRE_CURSO' ;

Cuenta de profesores

select

C.fullname ,

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 01 ) as 'Enero',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 02 ) as 'Febrero',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 03 ) as 'Marzo',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 04 ) as 'Abril',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 05 ) as 'Mayo',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 06 ) as 'Junio',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 07 ) as 'Julio',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 08 ) as 'Agosto',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 09 ) as 'Septiembre',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 10 ) as 'Octubre',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 11 ) as 'Noviembre',

(select COUNT(U.id) FROM mdl_user U INNER JOIN mdl_role_assignments RA ON RA.userid = U.id INNER JOIN mdl_user_lastaccess UL ON UL.userid = U.id WHERE RA.roleid = 5 AND UL.courseid = C.id AND DATE_FORMAT(FROM_UNIXTIME(UL.timeaccess), '%m') = 12 ) as 'Diciembre'

FROM mdl_course C

-- WHERE C.id = 3

WHERE fullname='NOMBRE_CURSO'

or fullname='NOMBRE_CURSO' ;

DEBES TENER EN CUENTA EL ID DEL ROL Y EL NOMBRE DEL CURSO, TAMBIÉN EL NOMBRE DE LAS TABLAS COMO VOS LAS TIENES

Promedio de calificaciones: -

Enlace permanente | Mostrar mensaje anterior | Responder

Muchas gracias por tu aporte desde Mar del Plata Argentina te envio un saludo. Claudio

Promedio de calificaciones: -

Enlace permanente | Mostrar mensaje anterior | Responder

Hola Claudio,

Hay muchas consultas SQL en esta página - https://docs.moodle.org/32/en/ad-hoc_contributed_reports - que le podría ser útil. Puedes echar un vistazo en los informes por Elizabeth Dalton para ejemplos buenos de informes de actividades de todos los cursos.

Tambien esos informes funcionan bien con los dos plugins 'Informes configurables' https://moodle.org/plugins/view.php?id=82 y 'Consultas ad hoc de la base de datos' (Ad-hoc database queries) https://moodle.org/plugins/view.php?id=176.

Saludos,

-Randy

Promedio de calificaciones: -

Enlace permanente | Mostrar mensaje anterior | Responder

Muchas gracias Randy por tu contribución , mis saludos Claudio

Promedio de calificaciones: -

Enlace permanente | Mostrar mensaje anterior | Responder

Cosas de Administradores

Reportes generales de Moodle

Nombres de los profesores

Cuenta de profesores