[Building Sakai] Report # of published assessments

[Doreen Minich]

Good Morning,
 
I'm working on a request to generate a list of courses/professors that used the Tests & Quizzes tool in their course during this past semester.  I can find the courses and the published assessments, but I missing the link between assessments and courses.  Would someone like to pass along the tables/fields I need to query so I can match the published assessment to a course?
 
TIA,
Dorie
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101213/93019127/attachment.html