Extracting Course IDS for specific faculty members

Discussion created by ma31099 on Dec 20, 2017
Latest reply on Dec 24, 2017 by ma31099

Hi All,


We are using ASR DB. I am looking for a query to extract list of course ID's to which faculty members A,B,C are connected/enrolled to. If this query can also show me the courses that has content and courses that do not have content.

Example: Faculty A.B,C are enrolled in 100 courses. I need to know all these 100 course ID's along with an excel column next to the course ids that says this course has content and this course has no content (null). The only information available with me in order to run this query would be users.pk1 or users.user_id



Ahmed Abdullah

LMS Administrator

Northern Border university