vchai
Active Member
In ERP 8.0, is there any way to check for inactive users? For instance, get a list of users who haven't signed on in more than 3 months.
Thanks,
Vincent
Thanks,
Vincent
DSauve
Legendary Poster
Vincent,
Sure. Turn on security history in your server's JDE.INI file -- if you haven't already done so. Then you can either use SQL or write a UBE that cycles through user ID's (F0092) and then look at the security history table (F9312) to find the ones that haven't logged in for the past 3 months. This is a VERY simplified description -- you'll have to do some coding or SQL, but it's definitely do-able.
Sure. Turn on security history in your server's JDE.INI file -- if you haven't already done so. Then you can either use SQL or write a UBE that cycles through user ID's (F0092) and then look at the security history table (F9312) to find the ones that haven't logged in for the past 3 months. This is a VERY simplified description -- you'll have to do some coding or SQL, but it's definitely do-able.
michel
Active Member
When you set password change frequency and you are not updating the user account using P98OWSEC you might use the "security last changed" field (P98OWSEC - Revise Sec).
It should tell you the last password change date.
It should tell you the last password change date.
ajlull
Active Member
You can also run the R98OWSECA. That will tell you information regarding last password change, change frequincy, active/inactive etc.
AJ
AJ
SULLY1
VIP Member
Vincent
You can also run P00960. It's not 100% reliable but pretty good.
Patty
You can also run P00960. It's not 100% reliable but pretty good.
Patty
