• 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
  • 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
  • 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
  • Query secondary intitutional roles

    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...
    cyndi.castro
    last modified by cyndi.castro
  • Adding a Time stamp for Portal Module Use

    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...
    tp36301
    last modified by tp36301
  • 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
  • How can I query for course images that have no alt tags

    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...
    lyondc
    last modified by lyondc
  • Query to pull total time on a test and the test grade?

    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. ...
    lee.mcminn
    last modified by lee.mcminn
  • Query for more than one instructor restricted by DSK

    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...
    tp36301
    last modified by tp36301
  • Rubric Scores Query

    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 * FROM rubric_cell_eval INNER JOI...
    km28576
    last modified by km28576
  • Query to find emails sent through Blackboard email tool

    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...
    km28576
    last modified by km28576
  • OpenDB SQL: Courses Using Course Themes

    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...
    chris.bray
    last modified by chris.bray
  • Add student forum attempts to an existing OpenDB query

    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...
    tp36301
    last modified by tp36301
  • Finding linked content

    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...
    jdiamant
    last modified by jdiamant
  • How do you find courses with no grades?

    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')...
    bishop.thomas
    last modified by bishop.thomas
  • Finding Object Deletion Records - DDA (OpenDB) or Log File?

    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...
    bishop.thomas
    last modified by bishop.thomas
  • Get Enrollment dates from STATS

    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...
    jdiamant
    last modified by jdiamant
  • Course Contents Queries

    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...
    km28576
    last modified by km28576
  • Gradebook score provider and Content Handler counting (OpenDB)

    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...
    bs28666
    last modified by bs28666