User's Last Login Date & Time in NAV

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

    Slawek
  • LefteyedLefteyed Posts: 36Member
    Session Event contains events .. when user login and sign out.
    Is that what you are looking for?
  • vivek4121vivek4121 Posts: 131Member
    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.