We are having a huge issues with departments who are using shared question banks. They banks have become massive and therefore so have the backup files, so we want to transition away from this practice. However, I'd like to be able to identify which quizzes contain any shared questions.
Is there any existing tool, or report, or query, or plugin that can help me locate these quizzes?
We are using Moodle 3.4.6 and I do have the ad-hoc query plugin but I'm not sure how I'd write that query, or if it's even possible.