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 from BB_BB60.cartridge_download cd, bb_bb60.course_main cm where cd.crsmain_pk1 = cm.pk1 order by cm.course_id desc but I don't feel… Show more

Kris, Thank you for the query. I added a few things to get a bit more information like instructor, etc. SELECT CD.DTCREATED, CM.COURSE_ID, CM.COURSE_NAME, CU.ROLE, U.USER_ID, U.FIRSTNAME, U.LASTNAME, U.EMAIL FROM CARTRIDGE_DOWNLOAD CD, COURSE_MAIN CM JOIN COURSE_USERS CU ON (CM.PK1 = CU.CRSMAIN_PK1) JOIN USERS U ON (CU.USERS_PK1 =…