Most of our external tools are activated at the root account level. The question I have been asked is how many assignments use a particular external tool (in this case, Turnitin). So there is an assignment and the instructor has set the submission type to External Tool and chosen Turnitin from the list.
I've looked at the assignment_dim table and can see the submission_types column so I filter on the 'external_tool' value. But I cannot figure out how to identify which external tool the assignment uses.
Does anyone know how I can find out using Canvas Data how many assignments use a particular external tool?