Moodle SQL list LTI activities and connected tools

moodle-list-lti-activities-and-connected-tool.sql

SELECT
    c.id AS course_id,
    c.fullname AS course_name,
    l.id AS lti_activity_id,
    l.name AS lti_activity_name,
    l.toolurl AS lti_tool_url,
    l.instructorcustomparameters AS custom_parameters,
    lt.id AS lti_type_id,
    lt.name AS lti_tool_name,
    lt.clientid AS lti_client_id,
		cm.id as cmid
FROM
    mdl_course c
JOIN
    mdl_course_modules cm ON cm.course = c.id
JOIN
    mdl_modules m ON m.id = cm.module AND m.name = 'lti'
JOIN
    mdl_lti l ON l.id = cm.instance
LEFT JOIN
    mdl_lti_types lt ON lt.id = l.typeid
ORDER BY
    c.fullname, l.name;