User's Last Login Date & Time in NAV

vivek4121

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!!

Slawek_Guzek

You can look into the Active Session table, you will find user ID and logind datetime in there

Slawek

Lefteyed

Session Event contains events .. when user login and sign out.
Is that what you are looking for?

vivek4121

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!!