• Sample or OpenDB/Oracle based DDA/Postgres Queries

    Has anyone documented some of there common queries to be converted from OpenDB that are Oracle based to Postgres for DDA after moving from SH or MH to SaaS?  Brett Stephens Joel Diamant Jeff Kelley   Glad t...
    tp36301
    created by tp36301
  • 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...
    natasha46
    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...
    kd0043639
    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...
    km28576
    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...
    lm29482
    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...
    je0078200
    last modified by je0078200
  • The Ultra Course Experience and ods submission tables

    We use the ods submission tables to pull information on student access and report it to advisors.  Are the ods submission tables populated with course activity in the Ultra Course Experience like they are for Ori...
    mf0052568
    created by mf0052568
  • 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...
    jkelley_blackboard
    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 ...
    bishop.thomas
    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? 
    rs0068755
    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...
    jm28915
    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 !!
    axelle.noiret
    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 ...
    dl0055113
    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?
    bh0076300
    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...
    jm28915
    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...
    lee.mcminn
    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 ...
    highland.hanrahan
    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...
    mattlingard
    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...
    bishop.thomas
    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...
    lm29482
    last modified by lm29482