User's Last Login Date & Time in NAV

vivek4121
vivek4121 Member Posts: 165
in NAV Three Tier
Hi All,

I need to get the user's last Login date and time in NAV for all the users in database? Is there any way to get this Info?

As the field "Time Register" is not enabled for all the users in the database?

Thanks in advance!!

Comments

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    You can look into the Active Session table, you will find user ID and logind datetime in there

    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • Lefteyed
    Lefteyed Member Posts: 43
    Session Event contains events .. when user login and sign out.
    Is that what you are looking for?
  • vivek4121
    vivek4121 Member Posts: 165
    Hi All,

    I got the desired results by creating the below query for session event table.
    SELECT [User ID], max ([Event Datetime]) As LastLoginDateTime
FROM [Session Event] where [Client Type] = 0 and [Event Type] = 0
Group by [User ID]

    Thanks!!

Categories