Report to Find External Tool Usage

Janelle Cleaves

• November 07, 2024 21:59

Hello all,

I am wanting to find a way of tracking down what classes are using what LTIs for the purposes of helping us get their LTI's updated to 1.3. Does anyone know of a way to do this?

Best,

Janelle

1

• 

  Jason Rodgers

  • February 14, 2025 17:44
  • Edited

  Would something like this help?

  Select MLT.name as LTItype,MLT.baseURL,MLT.ltiversion,  ML.course, ML.name, MC.fullname from mdl_lti ML
  LEFT JOIN mdl_lti_types MLT ON MLT.id=ML.typeid
  LEFT JOIN mdl_course MC ON MC.id=ML.course
  LEFT JOIN mdl_course_categories MCC ON MCC.id=MC.category
  
  where MCC.path like '/4/%' and MLT.name is not NULL 

  Change the above line with MCC.path to whatever category you want to limit your scan to.  If you want a full system scan then just remove the  MCC.path like '/4/%' part

   

  1
• 

  Janelle Cleaves

  • February 17, 2025 16:19

  Oh wow! That works super nice. Thank you so much. My only complaint is that there are some empty cells for the ltitype, baseurl, and ltiversion columns for certain courses. By looking into a few of those, I'm thinking they are either manually created LTIs or instances where the LTI was deleted at the site level but the activity remained in the course. Do you have any idea?

  1
• 

  Jason Rodgers

  • February 18, 2025 12:26

  Just looked in our instance and the blanks look to be the old manually created ones.
  
  You could add in ML.toolurl to the Select and it will show.

  1
• 

  Janelle Cleaves

  • February 18, 2025 20:38

  Gotcha. Good deal. I really appreciate this! Do you mind if I share with my peers?

  Additionally, I know virtually nothing about SQL and running the deferred admin reports. If you have any resources you recommend for learning more, please let me know!

  1

Please sign in to leave a comment.