on 2023 Jun 23 8:06 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.