Get last login date of user in SuccessFactors

[Former Member]

Is there a way using which I can get the Last Login Date of an user.

I tried by using Login Data report. but it is returning complete login information of users from the beginning. I just what only on record of when user last logged in.

[Aji_Kottayil]

HI niteshupare

Did you get any report logic to get latest login ?

[markfarn]

Hello All,

I was able to successfully create a last login report with a single entry per user. I did the following:
1. Report Center > Canvas Report > Add List Table Component > Detailed Reporting

2. Add last login details including access date and user info; this table has a record per user login, so it potential can have lots of records.; include a custom column to put first and last name into a single employee full name field.

3. From this table query, in Detailed Reporting, choose tool and Pivot Table Query and choose yes to start from your existing query

4. In the pivot query builder, drag Access Date into the middle to create a measure called last login and choose the Maximum function

5. The resulting pivot table should list each employee one time with the maximum login date as their last login date

Hope this helps!

Best Regards

Mark Farnan
HR Path

[former_member32812]

Hello, I was also not able to create. Any update or workaround found?

[Latyshenko2]

KBA 2947670 says it can be done with a canvas report; however, I have not been able to create it...