Moodle in English: LTI database tables

LTI and Moodle

LTI database tables

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

Tried and tried to find a table containing the LTI Name, Cartridge URL and Shared Secret and failed! Can anyone help please

Are you looking for the tables for the consumer (the "External tool" module) or the provider ("Shared as LTI tool" enrolment plugin)?

For the consumer it will be the _lti table. But you may have to check _lti_types mdl_lti_tool_proxies if you used the proxy / auto configure to create it.

_enrol_lti_lti2_consumer is the table for the enrol provider.

I'm interested to know why you need access to the tables. Generally everything you need to do should be doable from the interface.

I'm looking to build a report showing

custom instance name - cartridge url - secret

but can only find the secret within the LTI tables for me to build the SQL statement required