Log in to follow, share, and participate in this socialgroup. Not a member? Join Now! We need to get a list of IDs for courses in which there has been some grading activity (eg grades have been added to the Grade Centre by any means) within a specified time period (eg the past two academic years), for ... in the system admin gui I am able to open a course and select the course contents listing to obtain a list of content items like this: Course Content: W_ASV-133-03-JC-W18 FILE TYPE NAME EDITED SIZE ... Hi all, This is not a question as much as a thank you to all who have helped me with OpenDB. Here is one of my first queries any suggestions for improvement are welcomed: this give a list of users that have t... Greetings, I had modified a portal module query for distinctive users in OpenDB for a specific module used for 3rd party online course surveys. However, I like to able to see time stamps; however, I ha... We use a third party application called StarFish. This application pulls the grade from the column that's been set as the External Grade. I need to pull a report from OpenDB that shows me which column in e... Hi, I would like to track courses that have not being use during a specific term, either because they were not accessed by any instructor's or were not made available during this period. Or any other idea ? Thanks !! I can run this query: select cm.course_id,cc.title from course_contents cc,course_main cm where CNTHNDLR_HANDLE='resource/x-bb-image' and cm.pk1=cc.crsmain_pk1 It tells me the courses with images. I wo... Does anyone have or can you help me create a query to pull amount of time spent on a test and the grade for that attempt? Basically I need to collect the student's name, user_id, course_id, test name, and grade. ... Greetings, Does anyone have an OpenDB query handy for obtaining courses with more than one instructor restricted by DSK? I have a few more elaborate queries that I am attempting to break down but it wo... This query returns the cell level data of rubric evaluations. It includes joins to the course, gradebook, user, and rubric details. I hope this proves useful to someone. SELECT *
INNER JOI... I am trying to find data about emails that were sent through the Blackboard email tool. Specifically, I am looking for emails sent from the faculty to the student to measure faculty engagement, but just the table name... To prepare our campus in advance for the 2016 Bb Learn theme, we wanted to know which instructors and courses were using Course Themes. (Roughly 25%). This query returns the course ID, theme name, and instruct... Miroslav Lulic, I actually referred to this query yesterday and modified it with add the first and last name and targeting a set of Course IDs and a few other areas. It was originally from this forum: St... This request is content system based, so not useful for ASR connection to STATS - it might come in useful for those using openDB. I am looking for assistance with a query that will list the courses that a Cont... Using OpenDB, we need to find all active courses and their instructors of a given quarter/semester that have no grades in their Grade Center. This must exclude non-credit courses (having course numbers containing 'X')... Where would I look to obtain a record of user actions pertaining to the deletion of discussion forum postings? Is there a more detailed DB table than the activity_accumulator? Or are those events recorded in a log fil... I was asked this week if it is simple to obtain information about enrollments, particularly the date it was made. Here is a query with comments on how to go about this and this can be used on ASR connection to S... I came across this presentation online that has quite a few SQL queries in it: Open Database and DIY Analytics Here is a direct link to the queries: The SQL Server Query - Google Docs I haven't tested it yet becau... This query gives a list of all gradebook score providers (and their item counts) for all courses that match the pattern '%-20168' SELECT sp.name, gm.score_provider_handle, count(gm.pk1)
FROM bb_bb60.course_main cm
INN... Recently I've been helping a system admin investigate enrollment problems being experienced during SIS Complete Refresh processing. The SIS error logs for Complete Refresh will have a log message at the end tell...