Skip navigation
All Places > Bb Learn Data Reporting User Group > Blog

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 STATS.

 

SELECT U.USER_ID, CM.COURSE_ID, C.ENROLLMENT_DATE, C.DTMODIFIED

FROM COURSE_USERS C, COURSE_MAIN CM, USERS U

WHERE U.PK1 = C.USERS_PK1

AND CM.PK1 = C.CRSMAIN_PK1

AND C.CRSMAIN_PK1 = (SELECT PK1 FROM COURSE_MAIN WHERE COURSE_ID = 'COURSE_ID_GOES_HERE')

--AND c.ENROLLMENT_DATE > '01-SEP-16' --Used to filter on date

order by 3 asc;

Filter Blog

By date: