Learning Site users - last login time

[former_member78862]

Hello,

We are in a need of extracting information regarding the last login time of the Learning Site users in our system.

However, there is no report that would provide such information in LMS, apart from Customer Usage Data that only brings information for the last 3 months only. We would need to know Last Login Date for an extended period of time.

We also have enabled the IAS in our LMS test instance. I noticed that in IAS we can indeed extract this information via the Export Users tab, however, there is no way to differentiate the rows information regarding Last Login between a Site user and a normal user which comes from BizX.

In Export Users in IAS, when I select filter information such as application ID, identity provider, information is not brought back. If this information would be extracted, we would know which users are related to LMS Site, which is registered in IAS, as part of the IAS integration for LMS in test instance.

Is there any way to make this information available for Site users, regardless if its extracted from IAS or LMS instance?

Thank you!

Ioana

[Brian_Boegs]

Here is the rough SQL to get the data in a PRD report.

Not sure what happened to the Custom Report Exchange since they updated the Community.

SELECT LA.STUD_ID, LA.ATTEMPT_DATE, LA.ATTEMPT_SUCCESSFUL,

ST.STUD_ID, ST.PERSON_ID_EXTERNAL, ST.EMP_STAT_ID, ST.EMP_TYP_ID,

ST.JOB_TITLE, ST.FULLTIME, ST.REGULAR_TEMP_ID, ST.DMN_ID,

ST.ORG_ID, ST.REGION_ID, ST.LNAME, ST.FNAME, ST.MI, ST.NOTACTIVE, ST.CNTRY, ST.SUPER, ST.HIRE_DTE, ST.TERM_DTE, ST.EMAIL_ADDR, ST.SITE_ID

FROM PA_STUD_LOGIN_ATTEMPT LA, PA_STUDENT ST

WHERE LA.STUD_ID = ST.STUD_ID

ORDER BY ATTEMPT_DATE DESC

[former_member78862]

Thank you so much for your reply !

Have a nice day,

Ioana