Log user sessions

JanS

The system uses virtual tabel 2000000009 Sessions to keep track of current sessions in the database.
Unfortunately it cannot be used by the "change log" functionality, probably because it is a virtual table.
Does anyone know another way to log which users actually log into the NAV database, without having to purchase an add-on?

Thanks in advance for your suggestions.

Savatage

For us we go to g/l setup & select users, then user setup. Under each user their is a boolean field called register time. If you look at table 51 it has 3 fields:
-user id
-date
-minutes

(newer versions)
Administration --> IT Administration --> Users --> Time Registers

so if a user has that option checked in the user setup it logs all that info when they login.

Optional:
We added a few fields ourselves like Login Time, Logout Time, Number of Login, & Day.
You need to modify & add them to CU1 to get the info.

All viewed in Form 71. And report 10306 User Time Log.

Looks like this:

JanS

Thank you Savatage, I couldn't get Time Register to work. But I will look into it again.

JanS

Easy does it! Thanks very much.
Jan

Savatage

Your welcome. Just edit the first post & set the attibute to "Solved"