User's Last Login Date & Time in NAV

vivek4121vivek4121 Posts: 160Member
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_GuzekSlawek_Guzek Posts: 1,450Member
    You can look into the Active Session table, you will find user ID and logind datetime in there

    Slawek
    Slawek Guzek
    Poszukuje programistow znajacych Microsoft Dynamics NAV
  • LefteyedLefteyed Posts: 38Member
    Session Event contains events .. when user login and sign out.
    Is that what you are looking for?
  • vivek4121vivek4121 Posts: 160Member
    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!!
Sign In or Register to comment.