• Specify case sensitivity for Blackboard tests when designing outside of Blackboard?

    I am trying design tests in Blackboard that have many questions. I've been using MS Excel to make long collections of questions that I upload to Blackboard. This has been working very well and I've been able to use HT...
    last modified by natasha46
  • OpenDB Query to find course cartridge use?

    In preparation for the Course Cartridge EOL in December, I want to make sure we've contacted instructors using cartridges now. I ran a quick and dirty query, select cd.*, cm.course_id, cm.course_name, cm.dtmodified f...
    last modified by kd0043639
  • How can I tell if an Attempt was created by the student or professor?

    I am working on a query to identify the last time a student submitted an assignment. I use the ATTEMPT table fairly heavily, but have discovered that if an instructor enters a grade of 0 for a non-submitted discussion...
    last modified by km28576
  • Query Needed - mobile vs computer users

    Hi! We would like to begin gathering information regarding how many users access the system through computers versus mobile devices. Can this information be gathered through ASR? If so, is there a query that can...
    last modified by lm29482
  • OpenDB Query to Report Building Block Usage

    Does anyone happen to have a SQL query to report a Building Block's usage (the building block name would be part of the query) showing the building block name, date modified, hits in the last year, node, course id, an...
    last modified by je0078200
  • ETL from DDA (PostgreSQL) to Oracle?

    Looking for institutions who have implemented procedures to move data from the SaaS Open Database (DDA/PostgreSQL) environment to an Oracle based warehouse/reporting database.      What method(s) do yo...
    last modified by jkelley_blackboard
  • Has anyone created a process to review B2’s after a SaaS update?

    Occasionally, we find that Blackboard or one of their partners has introduced a new Building Block and made it available on our system without much notice. We want a quick way to verify any new B2s, and that building ...
    last modified by bishop.thomas
  • Moving to SaaS and DDA

    In the summer we will be moving from managed hosting with ASR to SaaS and the DDA.    Can anyone offer me any guidance on using DDA - what client are you using to run queries, any help guides etc? 
    last modified by rs0068755
  • Does anyone have a SQL query to pull SCORM scores for activities that are scored and if they were answered correctly?  Looking for a query that enables us to pull detailed data.

    We have a SME who requires a matrix to determine which questions/engagement that users are having difficulty with so they know what needs additional information/clarification in the training component when it is updat...
    created by jm28915
  • Query for courses not used during a term

    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 !!
    last modified by axelle.noiret
  • Content Collection SQL query similar to SysAdmin GUI Content Collection listing?

    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 ...
    last modified by dl0055113
  • Where does the attendance tool store its data?

    Does anyone know what table the attendance tool uses to store its data such as present, late, absent, and excused?
    last modified by bh0076300
  • Where find achievements in database.

    We're trying to pull a list of users who have earned badges (achievements) in our SaaS environment.  However, we are receiving an error that the ach_notification table does not exist.  I'm not certain if oth...
    last modified by jm28915
  • External Grade Designation

    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...
    last modified by lee.mcminn
  • OpenDB SQL query: courses in which grading has occurred

    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 ...
    last modified by highland.hanrahan
  • Any Tableau & Open Db Users?

    We are just starting to look at reporting from the Blackboard Learn Open Database. My institution has purchased access to it for a separate, wider learning analytics project but I'm keen that we take advantage for our...
    last modified by mattlingard
  • Determine Empty Courses

    I need to determine if certain courses are devoid of content at the start of term. Currently I use the following query which checks for zero course size and counts how many Grade Center columns there are. Blank course...
    last modified by bishop.thomas
  • Query that searches for content web links

    Hi everyone,   We had an interesting question from our librarians.  They are trying to identify courses that link to one of their resources. They provide a URL to the instructors and the instructors make th...
    last modified by lm29482
  • Master Course Management Needs for Online Campus

    Greetings,   Our online campus has brought this need to our attention.  I am not sure if this would be better for the Data Reporting Group for MH as we do use OpenDB so I am cross posting this.   This i...
    last modified by tp36301
  • Grade column report for all active courses

    Does anyone have a query to pull a particular grade column from all active courses using a date range,  with the following information displayed: student first name, last name, course id weighted grade colum...
    last modified by sharon.clucka