User access logging

I am seeking a way to determine which users logged into the system for a
given day... any tips?

B7332 AS/400 NTSQL Deploy SP13.1 Citrix


Active Member
I think on of the tables stores updates the time when they log in, you could
put a trigger on the table to log the action, you could also use a log on
trigger on your database is it exists on DB2. JDE might have some standard
methods for doing this but I just know the DB stuff. - Ethan Post


VIP Member
There are three easy way to tell who has been or is on the JDE system.

1. SAW - Swever Admin Workbench - okay but should do more
2. Netmon - works better than SAW to see who's currently online
3. F9312 - Security History table
4. W98OWSECC - Gives a view of the security history table

Of course to use the security history you need to turn this on in the
Enterprise server JDE.ini (SecurityHistory=1). Using this info you can get
some great reports about when users login and when, how long the avg user
stays logged in for, how many time a user logs in, what groups of users log
in the most, etc.


Colin Dawes, MSc
City of Guelph
B7332 SP13.1, Oracle 8.1.6, NT 4.0, Fat & WTS


VIP Member
Hey NIck (sorry for exposing you but I've got your email address memorized)

These reports have to be created from scratch (JDE should include them in
the base package). Business View V9312 is a good start. Some logic needs to
be considered as JDE logs each time a user logs on and each log off.
Here's a sample of the data that gets logged. Many great reports can be
generated from this information.

User ID User Class or Group Event Type Description
Event Status Description Machine
JSMITH ADMIN 01 Sign-on 01
JSMITH ADMIN 02 Sign-off
01 Success ADMIN_SRV

Event Date Event Time Updated By Update Program Date Signed
Off Time Signed Off
6/7/01 08:52:01 JSMITH JDESRV
6/7/01 11:27:03 JSMITH JDESRV

Just one note, if you turn on security history you'll get a bunch of
jde.log's on the Enterprise server due to some index constraint violations
by the jde foundation code. I don't know why this hasn't been fixed as
there's a really old SAR out for this.


Colin Dawes, MSc
City of Guelph
B7332 SP13.1, Oracle 8.1.6, NT 4.0, Fat & WTS