Queries
course_instance_active_enrollments.sql Course instances that are active within a given date range.
course_instance_compute_time.sql Course instances compute time within a given date range.
courses_with_chunks.sql Finds all courses that have chunks generated.
courses_without_chunks.sql Finds all courses that do NOT have chunks yet generated.
current_active_student_exams.sql Student exams that are being actively worked on at the moment.
current_activity_by_assessment.sql Assessments that have had submissions within a recent time interval.
current_activity_by_course_instance.sql Course instances that have had submissions within a recent time interval.
db_query_cancel.sql Cancel a running query (graceful kill).
db_query_terminate.sql Terminate a running query (hard kill).
db_running_queries.sql Queries currently running in the DB.
find_courses_by_user.sql Finds users and their courses.
generate_and_enroll_users.sql Generate random users and enroll them in a course instance
generate_assessment_instances.sql Simulates all students enrolled in a course starting an assessment (groupwork not supported)
generate_assessment_instances_group.sql Starts assessment instances for all groups in an assessment (groups must have been created)
instructors_by_institution.sql Return a list of instructors by institution
select_or_insert_user.sql Select or insert a user from the users table.
upcoming_exams.sql Exams currently running or about to start, with many students.
workspace_hosts.sql Select workspace hosts (currently active or recently terminated).
workspace_hosts_update_state.sql Update the state of a workspace host.
workspaces.sql Select currently active workspaces, grouped by course and assessment.