AnsweredAssumed Answered

Query the SQL database for users enrolled as teaching assistants

Question asked by richard.hancuff on Jan 15, 2018
Latest reply on Jan 17, 2018 by richard.hancuff

I'm trying to get a list of users who are enrolled in courses in the course/organization role of teaching assistant. Ideally, I would get a list of courses and the users with that role in that course.

 

I want to query the sql database for this information, but I'm not sure how to form the sql query as I'm not sure what table contains this information.

 

Has anyone else tried something similar to this?

 

Rich

Outcomes