SQL: List All Merged Blackboard Courses

Summary This query lists the parent and child course names of merged courses and is filtered by Course ID. Data Source: Blackboard DDA on SaaS […]

SQL: List All Courses Accessed by a System Role in the Last 7 Days

Summary This query lists all courses and organizations that have been accessed by a user with a specific system role in the last 7 days. […]

SQL: Total Number of Announcements Created Per Course

Summary Identifies the total number of announcements created per course. Data Source: Blackboard DDA on SaaS Code The post SQL: Total Number of Announcements Created […]

SQL: Students Who Have Not Logged In Within 7 Days

Summary With our recent move to remote instruction as a result of COVID-19, we needed a report to identify students who had not logged into […]

SQL: Find Courses with the Blackboard Collaborate Original B2 in the Course Menu

Summary This SQL query will return a list of courses that contains the Blackboard Collaborate Scheduling Manager Tool Link in the course menu. Code The […]

SQL: Find When a User is Created

Summary This SQL query will return a user’s Username, Batch ID, and Date created. Code The post SQL: Find When a User is Created appeared […]

SQL: List Courses Containing Users With A Specific Email Domain Enrolled

Summary This query will return a list of courses where users with a specific email domain are enrolled in. Use Case Our university uses academic […]

LOAD MORE
We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK