Log user sessions

JanS · 2012-08-14

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 · 2012-08-14

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 · 2012-08-15

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

JanS · 2012-08-15

Easy does it! Thanks very much.
Jan

Savatage · 2012-08-15

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

Log user sessions

Answers

Categories