STATS Reporting

/*List courses which have used the survey tool */

SELECT course_name, course_id FROM bb_bb60.COURSE_MAIN
WHERE pk1 IN (SELECT course_pk1 FROM bb_bb60_stats.activity_accumulator
WHERE INTERNAL_HANDLE LIKE 'cp_survey_manage'
AND TIMESTAMP BETWEEN TO_DATE('01-01-2010', 'DD-MM-YYYY') AND TO_DATE('01-05-2010', 'DD-MM-YYYY')
GROUP BY course_pk1);

/* Example of Internal Handle in activity accumulator */


SQL> select distinct internal_handle from bb_bb60_stats.activity_accumulator
2 where internal_handle like 'cp%';

INTERNAL_HANDLE
--------------------------------------------------------------------------------
cp_test_manager
cp_test_survey_pool
cp_gradebook2_manage_grading_schema
cp_tools_enable_bb
cp_course_statistics
cp_agroup
cp_manage_tools
cp_announcements
cp_course_utilities_recycler
cp_manage_groups_remove
cp_manage_groups_modify
cp_gradebook
cp_collaboration
cp_edit_availability
cp_manage_groups_add
cp_test_import
cp_password_modify
cp_add_group
cp_gradebook2_add_schema
cp_course_calendar
cp_manage_group
cp_course_options_area
cp_pool_import
cp_groups
cp_pool_manager
cp_list_modify_users
cp_manage_groups
cp_gradebook2_manage_download_grade
cp_add_users_create
cp_discussion_board