CD2 and LTI Usage

[IanGoh]

Got my hands on the LTI tables in CD2 now, trying to query if I can list all LTI 1.1 and 1.3 related to a specific course.

Context_External_Tools (LTI 1 and 1.3) - has two kinds of tools (context_type) - Account, Course

• if context_type: course, then I can use the context_id -> courseid
• if context_type: account, that just tells me it's installed at that context_id -> accountid and presumably everything underneath it (nested).

Do I then assume that if a courseid is nested under that accountid, that it's got the tool?  Where does it take into account the course navigation (visible vs hidden)?

I also looked at Lti_Resource_links, that gets me from Context_External_Tools -> Lti_Resource_Links -> Assignments, so at least I can get assignments using external tool (LTI 1.3 only)

So it seems two-fold

1) where LTI tools can appear (course navigation, assignments, etc) and then

2) unioning up the various sources at the course level.

Any ideas? Am I going about this the wrong way?

[IanGoh]

Hmm, so there are Lti_Resource_links w/ context type: course as well.

Do those Lti_Resource_links

• resource_link_uuid (UUID) – A UUID identifying the resource link.

go anywhere else? I don't see them linked on the Entity Relationship Diagram

[IanGoh]

Oh, it appears they didn't get me the context_external_tools.settings.custom_fields (at least) -- trying to replicate the LTI report in admin tools

Any others that are useful to determining which tools are really in a course?

[marco_divittori]

Do you mean the "LTI Report" within the account "Settings" area? The issue with that report is that it doesn't show course usage for tools that are installed globally (at the account level).

It looks like Instructure is adding LTI usage metrics to their new Intelligent Insights product offering.
https://community.canvaslms.com/t5/The-Product-Blog/Introducing-Intelligent-Insights-a-New-Product-O...

[IanGoh]

Right trying to avoid having to pay extra.  The LTI Report I can replicate to show my query is working (least once I get the settings.custom_fields)

But you are correct, context_external_tools only lists course tools (which we have few) and account tools (which we have many).  Eventually, I want an accurate picture of all LTI tools used within a course.