SF LMS PRD custom report - User Usage report

[chchew]

Dear All Expertise

Hope your doing well.

As above mentioned, I'm customizing a LMS PRD report in order to generate the list of user login transaction in LMS system. I did found the data dictionary to store the user login transaction is called "pa_login_session_info".

I did tried preview the result in PRD report and able to show the records, but once imported to the LMS system and generate the report there're no record generate. But doesn't have any error appear in the report. Might require your expertise to give some guideline on the reporting.

As below is the Report query.

select
a.LOGIN_ID,
a.LOGIN_TYPE,
a.LOGIN_TIME,
a.LOGOUT_TIME,
b.FNAME,
b.LNAME,
b.EMAIL_ADDR
from
pa_login_session_info a,
PA_STUDENT b
where a.LOGIN_ID = b.stud_id
/** AND a.LOGIN_TIME >= [SubmitDateFrom] AND NOT a.LOGIN_TIME > [SubmitDateTo]
AND [security:pa_student b] */

Appreciate your help.

Thanks

CJ Chew

[fgarayevaz]

Hi,

If the required option for SubmitDateFrom and SubmitDateTo is marked as checked then pls uncheck.