Last signon

Jack_Crouch

Well Known Member
OK... There is a setting on a user that says their password expires in x
days. And this appears to work.

So that tells me that somewhere in the DB lies the date that they last
changed the password.

Anyone know what file? (The F9650 is worthless for WTS....) (The
F0092 does not have anything...)

I want to find people who have not signed on...



AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
 
I don't know the table but here is something you could
try:

Make a user's password expire in a day or so
When the user is going to change their password turn
debugging on
Looking in jdedebug.log, see what tables it writes to



--- Jack_Crouch <[email protected]> wrote:
> OK... There is a setting on a user that says their
> password expires in x
> days. And this appears to work.
>
> So that tells me that somewhere in the DB lies the
> date that they last
> changed the password.
>
> Anyone know what file? (The F9650 is worthless
> for WTS....) (The
> F0092 does not have anything...)
>
> I want to find people who have not signed on...
>
>
>
> AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=5388
>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
 
Thanks... I will try that.

I found F9312 which is interesting. It is security history. It has
event types of:

01-Signon
02-Signoff
03-Password change
04-Sys Admin change
05-Add user
06-Delete user

But I only have event types of 4, 5, and 6 in the file. I wonder if there
is some INI setting or something that triggers the other event types to be
written?

Next deal is that this file is mapped to business data on our system.
Which is goofy as the security files and such should be cross environmental
and in SYSB733. So I have a bunch of F9312s out there.



AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
 
Jack, I would be interested in this one as well. It would be nice to check
this with deployments to workstations for complete verification.

Crawford
 
I use the F98OWSEC table. In the past we have had to change security and
force the issue by making the password expire in one day. I then monitor
this table to see when the password was changed. It gives you the date of
the change and the person that changed it. I hope this helps.

Thanks and have a great day,

Laurie Nelson
Wagstaff, Inc.
Phone: 509 922-1404, ext 3303
Fax: 509 892-6010
e-mail: [email protected]
ERP:  JDE OneWorld B733.1, SP 11.3
Tech: HPUX 11, Oracle 8.1.6, NT4/Win2K





Jack_Crouch
<[email protected] To: [email protected]
m> cc:
Sent by: Subject: Last signon ~~0:5388
owner-jdelistml@j
delist.com


02/10/01 09:55 AM
Please respond to
jdelist





OK... There is a setting on a user that says their password expires in x
days. And this appears to work.

So that tells me that somewhere in the DB lies the date that they last
changed the password.

Anyone know what file? (The F9650 is worthless for WTS....) (The
F0092 does not have anything...)

I want to find people who have not signed on...



AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=5388

*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Thanks Laurie. I had stared at the F98OWSEC over and over again... but I didn't realize that the update date in here noted the password change event.

That's great.

I still would like to know when people are signing off/on per my F9312 question... but this is better than nothing.

AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
 
Well... the book always helps. I have a CNC consultant who found the answer.

Turns out that if you put an entry in your JDE.INI on the ES like so:

[SECURITY]
History=1

Then your sign on/off events will be written to the F9312 file (which you can see via the Work with Security History function - form exit under User Security).

I did have to relocate the F9312 to the system map.

AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
 
Jack,
It is GREAT!
We also investigated how to keep track sign-on actions.
Now, here is the real and native solution.
Lot of thanks.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Back
Top